Here is how to change the auto increment value to say 10 on the table ‘test’:
ALTER TABLE test AUTO_INCREMENT 1;
Home
>
Change or Reset The Auto Increment Value Change or Reset The Auto Increment Value
No Comments »
No comments yet.
RSS feed for comments on this post. TrackBack URL
Leave a comment
Back To Top
Back To Previous Page
Author Bio
Hamid Alipour is a partner in Codehead, LLP with his wife, Tess. Hamid speaks 12 markup and programming languages [Yes, 12: PHP, CSS, Ajax, JavaScript, HTML/XHTML, Java, Python, C/C++, ASP, Visual Basic, Scheme and Action Script]; has a penchant for solving the unsolvable; an affinity for clean, hand-written code and is a Zend Certified 
Services
Blog
Tools
About
Contact
Blog Home