SQL

mysql set id auto increment

ALTER TABLE users AUTO_INCREMENT=1001;

change auto increment mysql

ALTER TABLE tbname MODIFY COLUMN columname smallint(5) auto_increment

update auto increment value in mysql

ALTER TABLE foobar AUTO_INCREMENT=10;

how to change the auto increment in existing table mysql

ALTER TABLE tbl_access ADD COLUMN `access_id` int(10) NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST

mysql get auto_increment value

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';