]
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
- Original Message -
From: "Rick 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 mysq
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
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
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
> )
>
>
