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
- where
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 year column with reference to the row id
: 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 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