t;
> Regards,
> m
>
> -Original Message-
> From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com]
> Sent: Friday, February 05, 2010 12:04 PM
> To: mysql@lists.mysql.com
> Subject: help me out for this problem...
>
>
>
> Here I have to update year column with
-> end
-> where id between 1 and 6;
Good luck!
Regards,
m
-Original Message-
From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com]
Sent: Friday, February 05, 2010 12:04 PM
To: mysql@lists.mysql.com
Subject: help me out for this problem...
Here I have to update
Here I have to update year column with reference to the row id
mysql> update table1
-> set year=case when id=1 then 2000
-> when id=2 then 2001
-> when id=3 then 2000
-> when id=4 then 2001
-> when id=5 then 2000
-> when id=6 then 2001
-> else 2003
