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
03 5:15 AM
Subject: setting auto increment start value
> 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
January 30, 2003 2:15 PM
Subject: setting auto increment start value
> 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
&g
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
--
-
Before posting, please check:
http://www.mysql