469,592 Members | 1,856 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

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

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
Jul 19 '05 #1
2 14102
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

Jul 19 '05 #2
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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Andrew | last post: by
2 posts views Thread by Dylan Nicholson | last post: by
6 posts views Thread by E | last post: by
2 posts views Thread by leegold2 | last post: by
6 posts views Thread by Brian Basquille | last post: by
reply views Thread by anzenews | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.