FROM mytable WHERE 1;
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 09, 2002 4:50 PM
To: [EMAIL PROTECTED]
Subject: Re: Re: Indexes on UPDATE/DELETE
sql,query
At 15:35 -0700 2/9/02, Andrei Cojocaru wrote:
Also, how do I reset an auto-increment
sql,query
At 15:35 -0700 2/9/02, Andrei Cojocaru wrote:
Also, how do I reset an auto-increment value back to 1 (with all
rows being already deleted of course).
ALTER TABLE tbl_name AUTO_INCREMENT = 1;
Thanks for your help in advance.
sql,query
At 15:35 -0700 2/9/02, Andrei Cojocaru wrote:
Also, how do I reset an auto-increment value back to 1 (with all
rows being already deleted of course).
ALTER TABLE tbl_name AUTO_INCREMENT = 1;
Thanks for your help in advance.
