How can i set all 'id' columns in my database in all table to autoincrement in one query?
is there a query that i can use?
Asked
Active
Viewed 20 times
0
-
Why not TRUNCATE? – P.Salmon Sep 01 '20 at 10:14
-
@P.Salmon how can i truncate that many tables? – flochristos Sep 01 '20 at 10:15
-
Read the table names from information_schema.tables. loop through them create sql statements for submission to dynamic sql - and I'm pretty sure if you search you will find. – P.Salmon Sep 01 '20 at 10:16
-
I've read it, i donn't really understand it. – flochristos Sep 01 '20 at 10:19
-
@P.Salmon *Why not TRUNCATE?* https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=8e484c6446805de8d2534b1682d12037 – Akina Sep 01 '20 at 10:26
-
Okay... i will try that... also is there a way to make all id column in the database to be auto incremeted – flochristos Sep 01 '20 at 10:36