: Am Donnerstag, 30. Januar 2003 20:15 schrieb Mike Doanh Tran:
: > Hi all,
: >
: > I am creating a new table with an auto_increment primary key.
: > How do i tell mysql to start incrementing at a certain
: value, let say
: > 1000 instead of 1?
: >
: > Thanks,
: >
: > MT
:
: SET INSERT_ID=1000 does it.
Tabels have "AUTO_INCREMENT" option, which you will need to set while
creating the table. In the following example id will start with 1000:
CREATE TABLE test (
id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
) AUTO_INCREMENT="1000";
Good luck
Sherzod
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
