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.
Hello fellow mySQL users,
I'd like to know if UPDATE/DELETE statements use indexes on the where
statement the same way as SELECTs.
If I build a SELECT using the WHERE statement that I use in an UPDATE/DELETE
statement, can I use that accurately to determine what indexes mySQL will
use
Hello fellow mySQL users,
I'd like to know if UPDATE/DELETE statements use indexes on the where
statement the same way as SELECTs.
If I build a SELECT using the WHERE statement that I use in an UPDATE/DELETE
statement, can I use that accurately to determine what indexes mySQL will
use
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.