Is there a mail where i can sent this topic to the developers ?
Mean while ill settle with perl.
Martin Ramsch wrote:
> On Tue, 1999-10-05 13:43:13 +0200, Ben-Nes Michael wrote:
> > Hi I wanted to do :
> >
> > UPDATE products SET Weight = '0.5' FROM products, rank WHERE
> > products.code = rank.code AND category = 'bell';
> >
> > And got answered that its impossible and all I can do is first do a
> > select then update the results.
> > This is a good solution only when i mange few items, but when i get back
> > hundreds of items its not enough.
>
> Why is it 'not enough' -- does it not work for you?
>
> But I agree, that it would be very good to extend the UPDATE syntax to
> allow for joins, too!
>
> Regards,
> Martin
> --
> Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/
> >
> PGP KeyID=0xE8EF4F75 FiPr=5244 5EF3 B0B1 3826 E4EC 8058 7B31 3AD7
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread15147@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-6-6925757
Fax: 972-6-6925858
http://www.canaan.co.il
--------------------------
