auto_increment in MySQL - can I omit it?
Posted
by kees-kist
on Stack Overflow
See other posts from Stack Overflow
or by kees-kist
Published on 2010-03-29T19:52:25Z
Indexed on
2010/03/29
19:53 UTC
Read the original article
Hit count: 303
mysql
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?
© Stack Overflow or respective owner
