List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:October 5 1999 11:54am
Subject:Re: UPDATE is not good enough in MYSQL
View as plain text  
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
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