Update multiple rows using one query

Can I update multiple rows using one query?

How to union following queries:

UPDATE tablename SET col1='34355' WHERE id='2'

UPDATE tablename SET col1='152242' WHERE id='44'
5
задан Juan Mellado 3 May 2012 в 21:07
поделиться