what is Cardinality and Collation means ?
Moderator: General Moderators
-
madan koshti
- Forum Commoner
- Posts: 50
- Joined: Fri Jun 06, 2008 4:25 am
what is Cardinality and Collation means ?
what is mean by mysql table Cardinality and Collation ?
Re: what is Cardinality and Collation means ?
A collation is a set of rules for comparing characters in a character set. http://dev.mysql.com/doc/refman/5.0/en/ ... neral.html
Cardinality is a measure of uniqueness for data in a row. It represents how different the rows in your table are from each other. http://en.wikipedia.org/wiki/Cardinalit ... tatements)
Cardinality is a measure of uniqueness for data in a row. It represents how different the rows in your table are from each other. http://en.wikipedia.org/wiki/Cardinalit ... tatements)
-
madan koshti
- Forum Commoner
- Posts: 50
- Joined: Fri Jun 06, 2008 4:25 am
Re: what is Cardinality and Collation means ?
What is mean by cardinality in integer value ?pytrin wrote:A collation is a set of rules for comparing characters in a character set. http://dev.mysql.com/doc/refman/5.0/en/ ... neral.html
Cardinality is a measure of uniqueness for data in a row. It represents how different the rows in your table are from each other. http://en.wikipedia.org/wiki/Cardinalit ... tatements)
e.g:
cardinality 5
cardinality 7
cardinality 10 etc... ?
Re: what is Cardinality and Collation means ?
It means how many unique rows you have in your table (according to the primary key)
-
madan koshti
- Forum Commoner
- Posts: 50
- Joined: Fri Jun 06, 2008 4:25 am
Re: what is Cardinality and Collation means ?
pytrin wrote:It means how many unique rows you have in your table (according to the primary key)
Hey Thanks..............