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?
Also, how do I reset an auto-increment value back to 1 (with all rows being
already deleted of course).
Thanks for your help in advance.
_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php