List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:February 20 2006 3:17pm
Subject:Re: Need Update Query Help (Urgent)
View as plain text  
>I wrote this below Query but it shows error how to write

>UPDATE table_1
>SET col_3 = 'bbb'
>WHERE  col_1 = (SELECT max(col_1) FROM table_1)

See the docs for Update at 
http://dev.mysql.com/doc/refman/5.0/en/update.html. You cannot refer to 
the update table in a subquery.

PB

-----

Veerabhadrarao Narra wrote:
> Hi
>
>   i ahve one table table_1 and columns like col_1,col_2,col_3
>
>     col_1   col_2  col_3
>     1       aa     aaa
>     2       bb
>
>   Now i want to update my table table_1 SET col_3 as bbb where max of col_1
>
> I wrote this below Query but it shows error how to write
>
> UPDATE table_1
> SET col_3 = 'bbb'
> WHERE  col_1 = (SELECT max(col_1) FROM table_1)
>   


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.11/264 - Release Date: 2/17/2006

Thread
Need Update Query Help (Urgent)Veerabhadrarao Narra20 Feb
  • Re: Need Update Query Help (Urgent)Jeff Shapiro20 Feb
  • Re: Need Update Query Help (Urgent)Peter Brawley20 Feb