mySQL quicky...

[Goksly]

Hello!
Ive used SHOW CREATE DATABASE and it returns some SQL (shock!) but includes "KEY <some name>(some columns)".
Im thinking this is creating an index, but looking at the online documentation.... well they always use the INDEX () SQL. So er yeah... can someone either confirm or slappppppppp down my idea of them being indexes. thanks

 

[happytechie]

KEY indicates which columns of the table make up the key being referenced. It is usual for 'key' columns to be implemented on the database as a unique index.

so yes they are indexes and yes they are the columns that make up that particuler key

HT