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 in message <[EMAIL PROTECTED]>... >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 first table, then delete the row in the >second table, third table, etc. Then loop for the next intance. Theres got >to be a better way. Also, after this is done should I run some sort compact >or defrag on the database that restore wasted space? > >Thanks, >Shaun > > >"Rick Emery" <[EMAIL PROTECTED]> wrote in message >news:[EMAIL PROTECTED]... >> Are you trying to delete records with a SELECT statement? That can't be >> done. >> >> To delete from two different tables, you must use two different DELETE >> statements. >> >> -----Original Message----- >> From: Shaun Honsvick [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, October 16, 2001 3:59 PM >> To: [EMAIL PROTECTED] >> Subject: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in >> mysql >> >> >> I am trying to run a delete on a mysql database. The delete query needs to >> delete from 2 tables. The select statement is: >> >> SELECT tinvoices.*, ttrackingnumbers.* FROM tinvoices LEFT JOIN >> ttrackingnumbers ON tinvoices.InvoiceID = ttrackingnumbers.InvoiceID WHERE >> Date < '2001-08-01'; >> >> I can't seem to get a delete statement to work. (This is my first project) >> >> Thanks, >> Shaun >> >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]