MySQL: Auto Increment

SELECT AUTO_INCREMENT
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = "databaseName"
AND TABLE_NAME = "tableName"

alter table tablename auto_increment = newvalue

Luis Romero

Say thanks

Last edit

2014-05-20

Posted by Luis Romero to Custom Exposure (2014-05-20 01:44)