List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 5 1999 1:21pm
Subject:Re: UPDATE is not good enough in MYSQL
View as plain text  
At 8:10 AM -0500 10/5/99, Ben-Nes Michael wrote:
>Is there a mail where i can sent this topic to the developers ?

They're already well aware of it, don't worry.


>Mean while ill settle with perl.

That's one of the usual solutions.  You're in good company.


>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!

--
Paul DuBois, paul@stripped
Thread
UPDATE is not good enough in MYSQLBen-Nes Michael5 Oct
  • Re: UPDATE is not good enough in MYSQLMartin Ramsch5 Oct
    • Re: UPDATE is not good enough in MYSQLMichael Widenius7 Oct
  • Re: UPDATE is not good enough in MYSQLTonu Samuel5 Oct
  • Re: UPDATE is not good enough in MYSQLBen-Nes Michael5 Oct
    • Re: UPDATE is not good enough in MYSQLPaul DuBois5 Oct