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
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