No offense but if you didn't want to hear that type of "discussion" and you
knew sub-selects weren't supported, you would get a "more correct" response
if you started with "I know sub selects aren't supported but how can I
change this SQL statement to have the same effect in MySQL" or words to that
effect. This indicates to everyone that you have at least read the manual.
"HOW can I implement this in MySQL?" means nothing. It doesn't clearly show
that you have tried to find the information for yourself first.
The way the original message was written, most people on this list would
have taken it to mean that Lieven is a newbie who hasn't yet read the manual
for whatever reason and I think most people would have replied in a similar
manner, "read the manual". Myself included.
If you are going to post to the list, at least show that you have done your
own work first and your not just out for a free ride. Quote code or parts
of the manual, tell us what you've tried, etc.
Now for the answer or I should say my answer. Do it programmatically in PHP
or whatever, until sub-selects are supported.
----- Original Message -----
From: "Canadian Lumberer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 11:50
Subject: Re: DELETE statement
> Hello,
>
> Personally, I am sick and tired of discussions like that.
>
> On Sun, Feb 18, 2001 at 09:36:47AM -0800, Fredrick Bartlett wrote:
> > I will kindly answer...
> Thank you Fredrick! But your answer is not the answer Lieven wanted and me
too, by the way.
>
> > Subselects are not supported in current released versions of mySQL.
> I have seen a lot of answers like that. But as I mentioned above it's not
> the answer.
>
> > Fred van Engen wrote:
> > > On Sun, Feb 18, 2001 at 05:23:02PM +0100, Lieven Op De Beéck wrote:
> > > > DELETE FROM product
> > > > WHERE product.id in
> > > > (SELECT p.id
> > > > FROM product p, category c
> > > > WHERE p.cat=c.id AND c.subcatfrom=2)
> Probably, Lieven, we'll have slightly better chance to receive the REAL
ANSWER
> if we ask "HOW can I implement this in MySQL?" with small addition "I am
> using PHP (C API, Perl, GUI client, command line clien - underline what is
> your case)."
>
> Friends, seriously, could you please post working solutions for cascade
> delete, update? Did I miss some FAQ? Site? Page? Post?
> Everntualy, I'll end up with such solution because I need it. But do I
really
> need to invent wheel?
>
> > > You forgot to read the manual.
> > > Fred.
> Do you have to say something else? If the answer is "No", could you please
> avoid to make quite busy list busier?
>
> Best regards,
> Lumberer.
>
> P.S. Excuse me, please, everybody who finds this post too offensive.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
