Canon Eos Digital Solutions Disk Iso Software Systems. PHP and MySQL tutorials, News, Downloads and Forums. Teach you step-by-step with easy simple php code. I know that you can insert multiple rows at once, is there a way to update multiple rows at once (as in, in one query) in MySQL? Edit: For example I have the following Name id Col1 Col2 Row1.

I am trying to understand how to UPDATE multiple rows with different values and I just don't get it. The solution is everywhere but to me it looks difficult to understand. For instance, three updates into 1 query: UPDATE table_users SET cod_user = '622057', date = '12082014' WHERE user_rol = 'student' AND cod_office = '123456'; UPDATE table_users SET cod_user = '2913659', date = '12082014' WHERE user_rol = 'assistant' AND cod_office = '123456'; UPDATE table_users SET cod_user = '6160230', date = '12082014' WHERE user_rol = 'admin' AND cod_office = '123456'; I an example, but I really don't understand how to make the query. Weeds Control Without Poisons Pdf Printer. I.e: UPDATE table_to_update SET cod_user= IF(cod_office = '123456','622057','2913659','6160230'),date = IF(cod_office = '123456','12082014') WHERE??

IN (??); I'm not entirely clear how to do the query if there are multiple condition in the WHERE and in the IF condition.any ideas? MySQL allows a more readable way to combine multiple updates into a single query. This seems to better fit the scenario you describe, is much easier to read, and avoids those difficult-to-untangle multiple conditions. INSERT INTO table_users (cod_user, date, user_rol, cod_office) VALUES ('622057', '12082014', 'student', '123456'), ('2913659', '12082014', 'assistant','123456'), ('6160230', '12082014', 'admin', '123456') ON DUPLICATE KEY UPDATE cod_user=VALUES(cod_user), date=VALUES(date) This assumes that the user_rol, cod_office combination is a primary key. If only one of these is the PK, then add the other field to the UPDATE list.

If neither of them is a primary key (that seems unlikely) then this approach will always create new records - probably not what is wanted. However, this approach makes prepared statements easier to build and more concise.