Set autoincrement value for ALL tables in MySql

Question

Is there a way I can set an autoincrement value for all the tables in my database to be (say) 1001 rather than 1. My DB has tens of tables, I want to set all the auto-increment fields to start from 1001

I don't want to go and do an alter table query on each table.. I'm looking for a QUICK and easy way to alter all the tables?

Thanks!

SQL is fine, but set auto0increment for all (tens of tables) to 1001 — WonFineDay, Dec 08 '15 at 20:46

score 0 · Answer 1 · answered Dec 08 '15 at 19:33

0

Run this SQL Query: ALTER TABLE NameOfTable AUTO_INCREMENT = 1000;

It will start the count from 1000.

answered Dec 08 '15 at 19:33

Ramos Alcarez Jr

19
5

2

This is answering the wrong question. I want to modify for ALL tables. My DB has tens of tables, I want to set all the auto-increment fields to start from 1001. – WonFineDay Dec 08 '15 at 20:44
So you want all tables to start from 1001? – Ramos Alcarez Jr Dec 08 '15 at 21:41

Set autoincrement value for ALL tables in MySql

1 Answers1