lt;[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 12:37 PM
Subject: RE: very tough query
Here's what happens:
ERROR 1064: You have an error in your SQL syntax near ' poll_answers,
poll_votes where (poll_questions.poll_id = poll_answers.poll_id) ' at line 1
-Original Mes
From: Daren Cotter <[EMAIL PROTECTED]>
> ...what happens when I want to delete a poll?
Do it machanically. That is, do a query in advance to find the data that needs to be
deleted, then go through and delete it. The logic for joining a delete can be written,
but MySQL doesn't support it. (Hey
ED]]
Sent: Tuesday, March 05, 2002 8:27 AM
To: [EMAIL PROTECTED]
Cc: Daren Cotter
Subject: Re: very tough query
Hi Darren,
On Tue, 5 Mar 2002 09:42:50 -0800
"Daren Cotter" <[EMAIL PROTECTED]> wrote:
> mysql> desc poll_questions;
> ++---
Hi Darren,
On Tue, 5 Mar 2002 09:42:50 -0800
"Daren Cotter" <[EMAIL PROTECTED]> wrote:
> mysql> desc poll_questions;
> ++-+--+-++-
> ---+
> | Field | Type| Null | Key | Default| Extra
> |
> +
ok, here are the 3 tables i have that are related:
mysql> desc poll_questions;
++-+--+-++--
--+
| Field | Type| Null | Key | Default| Extra
|
++-+--+-++
