sorry if this is painfully obvious but I can't seem to
figure it out...It seems to me (unless I am reading it
waay wrong) that the mysql DELETE command does NOT
allow you to refer to columns from other tables!
I have identified certain records to be deleted from 3
tables and created a temp table
gt; > -Original Message-
> > From: Adv. Systems Design
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 01, 2002 2:43 PM
> > To: PHP List
> > Subject: [PHP-DB] DELETE in mysql?
> >
> >
> > sorry if this is painfully obvious but
: Friday, February 01, 2002 2:43 PM
To: PHP List
Subject: [PHP-DB] DELETE in mysql?
sorry if this is painfully obvious but I can't seem to
figure it out...It seems to me (unless I am reading it
waay wrong) that the mysql DELETE command does NOT
allow you to refer to columns from other tables
ltiple rows, which
> row in temp would MYSQL check against to determine
> prod_id?
>
>
> -Original Message-
> From: Adv. Systems Design
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 01, 2002 2:43 PM
> To: PHP List
> Subject: [PHP-DB] DELETE in mysql?
, which
> > row in temp would MYSQL check against to determine
> > prod_id?
> >
> >
> > -Original Message-
> > From: Adv. Systems Design
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, February 01, 2002 2:43 PM
> > To: PHP List
> >