This actually is more tricky than it sounds.
Firstly the table already exists. So create table is
an option only if you were going to recreate a new
table with an auto_increment column, then move the
rest of the data (except for the index column) in to
the new table, drop the old table and re-n
: 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,
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.
Have a look at
http
At a guess, I'd set the default value to 1000 so the first record you insert
has 1000 as it's value, then it will continue on from there.
- Original Message -
From: "Mike Doanh Tran" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 5:15 AM
Subject: setting auto
>From postings at:
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
ALTER TABLE tbl_name AUTO_INCREMENT = 1000
will start your records at 1000
Bhavin.
- Original Message -
From: "Mike Doanh Tran" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 30, 2003 2:15 PM
S
