Hey all,
Just having a problem with a database I'm working with. I used to have a MYISAM database which let me set the auto-increment to whatever I wanted it to be (via phpMyAdmin).
I'm now using innodb tables to allow me to use transactions, but I find that if I set the auto increment value, it just forgets the value and returns to 1 again.
Is there any way I can force it to start from an arbitrary number? Say .. 117340?
Cheers
(mysql 3.23.58 - php 4.3.11)
Set auto-increment with mysql - innodb [SOLVED]
Moderator: General Moderators