Re: Using 1 statement to delete from 2 tables

2004-04-14 Thread Richard Davey
Hello B., Wednesday, April 14, 2004, 7:02:06 PM, you wrote: BF> I'm using an older version of Mysql, and I know it doesn't support BF> trigger. What I'm trying to do, is to delete records from 2 tables BF> (Sessions & Cart). In a nutshell - you cannot do it in a single SQL Query on MySQL 3.x MyS

Using 1 statement to delete from 2 tables

2004-04-14 Thread B. Fongo
I'm using an older version of Mysql, and I know it doesn't support trigger. What I'm trying to do, is to delete records from 2 tables (Sessions & Cart). These experimental statements didn't help: DELETE FROM Sessions INNER JOIN Cart on Sessions.id where Sessions.id ="$id"; DELETE FROM Sessio