multiple updation using single mysql query
Posted
by Ajith
on Stack Overflow
See other posts from Stack Overflow
or by Ajith
Published on 2010-04-21T11:12:11Z
Indexed on
2010/04/21
11:23 UTC
Read the original article
Hit count: 165
mysql
I need to update multiple rows with different values.Is it possible to do in mysql? ie,some thing like this
UPDATE landing_page SET (rotation_slot_begin='0',rotation_slot_end='0.333333333333' where landing_pageid=265),(rotation_slot_begin='0.333333333333',rotation_slot_end='0.666666666667' where landing_pageid=267),(rotation_slot_begin='0.666666666667',rotation_slot_end='1' where landing_pageid=268)
but this query is not working.I think something like this.Anybody can help me please
© Stack Overflow or respective owner