On Mon, Mar 25, 2002 at 02:42:08PM -0800, Andr?s Felipe Hern?ndez wrote:
Hi, I hope you can help me with this:
I have these 3 tables.
exam (
exam_id
)
questions (
question_id
exam_id
)
answers (
answer_id
question_id
)
I am wondering if
if you are using mysql 4.x, you might try:
DELETE answers FROM exam e, questions q, answers a WHERE
a.question_id=q.question_id q.exam_id=e.exam_id;
I've not tested this, though.
-Original Message-
From: Andrés Felipe Hernández [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002
this solution will not work for mysql databases, as mysql does not support
sub-selects
-Original Message-
From: Bill Morrow [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 2:02 PM
To: Andr?s Felipe Hern?ndez
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] delete statement question
Emery [EMAIL PROTECTED]
To: Andr?s Felipe Hern?ndez [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 25, 2002 12:03 PM
Subject: RE: [PHP-DB] delete statement question
this solution will not work for mysql databases, as mysql does not support
sub-selects
-Original Message-
From
]
Subject: Re: [PHP-DB] delete statement question
Rick, thanks for the idea but actually it wouldnt work :(
take a look:
mysql delete answers
- from exam e, questions q, answers a
- where a.question_id=q.question_id and q.exam_id=e.exam_id;
ERROR 1064: You have an error in your SQL syntax