Page 1 of 1

My SQL AI

Posted: Sat Sep 03, 2011 8:47 am
by YoussefSiblini
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.

Code: Select all

ALTER TABLE antiques AUTO_INCREMENT = 1
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:

Code: Select all

ALTER TABLE antiques , users , members AUTO_INCREMENT = 1
but I am getting error.
Is it possible to do that?

Re: My SQL AI

Posted: Sat Sep 03, 2011 10:38 am
by McInfo
Use three separate queries.

Re: My SQL AI

Posted: Mon Sep 12, 2011 7:40 am
by YoussefSiblini
Thank you that did it, and I saved the queries in a MW document so I just copy and paste the queries since I have 28 queries now.