multiple updation using single mysql query
- by Ajith
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