what is Cardinality and Collation means ?
Posted: Wed Jun 25, 2008 5:13 am
what is mean by mysql table Cardinality and Collation ?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
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)
pytrin wrote:It means how many unique rows you have in your table (according to the primary key)