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

Filed under:

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

Related posts about mysql