My SQL AI
Posted: Sat Sep 03, 2011 8:47 am
Hi,
Lets say I have 3 tables in the data base, I want the AI to start from 1 again,do I have to do every table individual or is there a way to do all of them together.
I use the code above for the antiques table, so if I want to do that for the tables: antiques, users and members, I tried this code:
but I am getting error.
Is it possible to do that?
Lets say I have 3 tables in the data base, I want the AI to start from 1 again,do I have to do every table individual or is there a way to do all of them together.
Code: Select all
ALTER TABLE antiques AUTO_INCREMENT = 1Code: Select all
ALTER TABLE antiques , users , members AUTO_INCREMENT = 1Is it possible to do that?