Useful sql (auto_increment)

1. SELECT  auto_increment

 

SELECT Auto_increment
FROM information_schema.tables
WHERE table_name='the_table_you_want' /* Can end here if only 1 DB */
  AND table_schema = DATABASE(); /* See comment below if > 1 DB */

 

From:

http://stackoverflow.com/questions/933565/get-auto-increment-value-with-mysql-query

 

2. UPDATE  auto_increment

 

alter table the_table_you_want auto_increment = 1;