dan
-
Posts
31 -
Joined
-
Last visited
Posts posted by dan
-
-
Hey! you're not elvis!!
-
Elvis
-
Try
ALTER TABLE `your_table` AUTO_INCREMENT=123
where 123 is the value for the next row to be inserted
-
In most cases you actually want it to keep incrementing so you don't end up with messed relations when you have multiple tables referencing eachother.
However, I think the easiest way is to drop the column that has the auto inc and then re-add it. I think there's a way to use the alter command and set the autoincrement value for the next add. But I don't know exactly without finding my sql books.
-
As someone from Sweden, who has lived in Norway for the last 4-5 years I'd like to say: ZeZar you don't know what you're talking about. You go to a place one time and you decide it sucks..
-
Haha, thanks.. I actually have a use for that word!
-
-
Don't you go knocking buddy christ!
thanks
-
A Volvo 343 1.4 DL from 1979
-
My car > all of yours
Fine then! But it's probably older than most of you..
-
Douglas Adams - Last Chance To See - 4 to 7
-
YOUR Ancestors
in General Discussion
Posted
I hail from martians.