Re: [PHP-DB] Deleting form multiple tables

2002-01-03 Thread Miles Thompson
Not as I understand the docs. Very few relational databases do. Miles Thompson At 10:52 AM 1/3/2002 -0800, olinux wrote: >Does mysql not support deletes from multiple tables? > >[ie] DELETE FROM vendors, billing WHERE vendors.v_id = >'1' AND vendors.vb_id = billing.b_id > >Thanks much, >olinux

RE: [PHP-DB] Deleting form multiple tables

2002-01-03 Thread Rick Emery
Multiple-table delete was implemented with MYSQL vers 4.0 -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 12:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Deleting form multiple tables Does mysql not support deletes from multiple tables? [ie

[PHP-DB] Deleting form multiple tables

2002-01-03 Thread olinux
Does mysql not support deletes from multiple tables? [ie] DELETE FROM vendors, billing WHERE vendors.v_id = '1' AND vendors.vb_id = billing.b_id Thanks much, olinux __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.