Keys

[Sharif]

Can someone explain what the following are used for?

Primary, Index, Unique, Full TEXT

[LordShryku]

the manual can

[Sharif]

Lord Shryku, I was reeading on the keys here: http://www.mysql.com/doc/en/CREATE_TABLE.html ... I just don't get it - it's all so mushed together, my eyes hurt. Why can't it be like php.net ?

[drawmack]

why can't people take classes at their local uni?

[LordShryku]

Hey Sharif....download it then. Apply a CSS that's more suitable to you.

[superwormy]

Primary Key - fancy index
Index - a key thats used for faster access to the database records. If you did a shatload of queries always selecting off one key:

SELECT WHERE thing = $var
SELECT WHERE thing = $var2
SELECT * WHERE thing = $var3

You might want to put an index on 'thing' for faster access

Unique - um... DUH? Pretty self explanatory...