mysql - why mysql5.5 AUTO_INCREMENT dose not affect? -


here question: have table (innodb), max primary-key value 5000000, user alter table tb set auto_increment = 20000; when on local, it's ok; on server, auto_increment still 5000000. can me?

@inkparker should work.

alter table tb auto_increment = 5000000; 

Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -