select tab.TABLE_NAME, tab.AUTO_INCREMENT from information_schema.TABLES tab where tab.TABLE_SCHEMA = 'your_schema_name';

delete from table_name;

truncate table table_name;

ALTER TABLE table_name AUTO_INCREMENT = 1;