var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alter AUTO_INCREMENT value....
I'm quite new to MySQL, that's why I have a question about the AUTO_INCREMENT function.
Can you tell me what the syntax is to change the value of an AUTO_INCREMENT column? I get this error when I type the following:
ALTER TABLE `blah` SET AUTO_INCREMENT = 175
I am missing something here and the manual doesn't tell me what command to use. Let's hope you can help me. Thanks!
insert a dummy row
lets say auto increment column is id
insert into TBL (id) values (174);
next time u do a normal insert the auto inc column will bet set to 175
u can delete the dummy row at any time after its insert
You don't need "SET"...
Originally Posted by acwibier
All you need to do is...
Hope this helps!!
ALTER TABLE `blah` AUTO_INCREMENT = 175
Alex J. Fierro
Alex Fierro Web Design