5 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Newbie Question: Convert SELECT to DELETE
statement in mysql
No, I am not trying to delete with a select statement. That was just there
to show my tables, fields, etc.
So if I understand what you are saying I can not do a delete statement with
a join in i
Hi!
In MySQL-4.0.0 you can delete from several tables in a join:
DELETE t1, t2 FROM t1, t2, t3 WHERE ...;
But 4.0.0 is still alpha, and it will take some months for it to
stabilize. No compact or defrag is normally needed with
MySQL.
Regards,
Heikki
http://www.innodb.com
Shaun Honsvick wrote
No, I am not trying to delete with a select statement. That was just there
to show my tables, fields, etc.
So if I understand what you are saying I can not do a delete statement with
a join in it. I would have to query each individual row for the ID that need
to be deleted, delete the row in the