Best unofficial Apache Server developers community |
|
Hello all, I'am new to mysql and i want to know what KEY (not primary key) means in the query below :
also this line
posted via StackOverflow
|
|
 
|
A KEY is an index: it's just like a library index: quicker finding for the values of that colum. You want this for joining and searching.
Means the engine you use (this is the default). If you need foreign keys for example, then you might want InnoDB.
Is the default character set.
Means that currently the auto-increment value is at 65. |
|
 
|
|
|
 
|
It is a index key use for foreign key relationship with other tables. |