How to set all auto increments to 1 in a Schema Is it possible to reset all auto increment in a schema in one query? if not even just by per table will do. btw I am using MySQL server 8 thanks in advance :)
If the tables already have rows, you can't do it.

If you want to throw away all the data, then you could do TRUNCATE TABLE for each table.

Or you could get all the table definitions via mysqldump --no-data and make sure there are DROP TABLE for each.  Then have a script that runs the output.