alter table 'table' auto_increment = # doesn't work

[Ittay Freiman]

i cannot set auto_increment to start from anything other than 1:

mysql> create table test (id int unsigned not null auto_increment primary key);

mysql> alter table test auto_increment=2;

mysql> insert into test() values();

mysql> select * from test;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.00 sec)
please help,
ittay

[2metre]

try

mysql> alter table test SET auto_increment=2;
"Ittay Freiman" <it***@qlusters.com> wrote in message
news:1a*************************@posting.google.co m...

i cannot set auto_increment to start from anything other than 1:

mysql> create table test (id int unsigned not null auto_increment primary key);
mysql> alter table test auto_increment=2;

mysql> insert into test() values();

mysql> select * from test;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.00 sec)
please help,
ittay

[2metre]

try

mysql> alter table test SET auto_increment=2;
"Ittay Freiman" <it***@qlusters.com> wrote in message
news:1a*************************@posting.google.co m...

i cannot set auto_increment to start from anything other than 1:

mysql> create table test (id int unsigned not null auto_increment primary key);
mysql> alter table test auto_increment=2;

mysql> insert into test() values();

mysql> select * from test;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.00 sec)
please help,
ittay