updating multiple fields in mysql

Asked Jul 14 '16 at 09:15

Active Jul 14 '16 at 10:05

Viewed 34 times

i have the database as below

Name   id  Col1   
Row1   1    0      
Row2   2    1      
Row3   3    1

if i submit query...result should be as below

Name   id  Col1   
Row1   1    1       
Row2   2    0     
Row3   3    1

 Name   id  Col1   
    Row1   1    1       
    Row2   2    1     
    Row3   3    0

like so on... finally

 Name   id  Col1   
        Row1   1    0       
        Row2   2    1     
        Row3   3    1

i tired CASE statement in mysql...but not worked

edited Jul 14 '16 at 10:05

Arif

asked Jul 14 '16 at 09:15

Uday Laddu

2

Check this http://stackoverflow.com/questions/3432/multiple-updates-in-mysql – Yuri Jul 14 '16 at 09:17
where is your code which you have tried.? – Passionate Coder Jul 14 '16 at 09:17
UPDATE page SET STATUS = CASE id WHEN 0 THEN 1 WHEN 1 THEN 0 END WHERE id IN (1, 2, 3); its loop...wanna run in script – Uday Laddu Jul 14 '16 at 09:22
What will be your end result?? – Ankit Bajpai Jul 14 '16 at 10:15

0 Answers0