auto_increment in MySQL - can I omit it?
- by kees-kist
I've noticed that PHPmyAdmin creates the following SQL for table creation:
CREATE TABLE something (
...
) auto_increment=1;
When I write a database creation script I don't use the auto_increment bit. From reading related questions here I understand that it determines the starting value for auto_increment values. But it is good practice to reset it to 1, or should I just leave it out of the SQL so that the default is used?