Re: auto increment starting number?

[Joao Prado Maia]

Hi Shawn,

Yes, you can. You just need to pass "auto_increment=<number>" as a table creation options. See example below:

mysql> CREATE TABLE testing (
-> id int(10) unsigned NOT NULL auto_increment,
-> another_id int(10) unsigned NOT NULL default '0',
-> PRIMARY KEY (id)
-> ) auto_increment=3000;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into testing values (null, 123);
Query OK, 1 row affected (0.00 sec)

mysql> select * from testing;
+------+------------+
| id | another_id |
+------+------------+
| 3000 | 123 |
+------+------------+
1 row in set (0.00 sec)

Hope that helps.

Cheers,
Joao Prado Maia
MySQL AB