MySQL: View table status and Edit auto-increment

  • How to view table status to see details like auto-increment value and how to change them.

SHOW TABLE STATUS LIKE "[table_name]"
ALTER TABLE [table_name] AUTO_INCREMENT = 100;


References:
     12.4.5.38. SHOW TABLE STATUS Syntax
     3.6.9. Using AUTO_INCREMENT

- _

Add Comment

Sorry you must log in first to be able to add a comment. Click here to log in.
*/ ?>