Re: Newbie Question: Convert SELECT to DELETE statement in mysql

I haven't done a lot of mySql, but does it have a 'cascade' option when you're creating tables? This allows you to define a foreign key relationship, so that when you delete your master record, the associated child records are also deleted. Sheila Rick Emery wrote: > > 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:shonsvick@ce-group.com] > Sent: Tuesday, October 16, 2001 3:59 PM > To: php-db@lists.php.net > 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net