UPDATE multiple rows with different values in one query in MySQL

by

You can do it this way:

UPDATE table_users
    SET cod_user = (case when user_role="student" then '622057'
                         when user_role="assistant" then '2913659'
                         when user_role="admin" then '6160230'
                    end),
        date="12082014"
    WHERE user_role in ('student', 'assistant', 'admin') AND
          cod_office="17389551";

I don’t understand your date format. Dates should be stored in the database using native date and time types.

More Related Contents:

  1. MySQL, update multiple tables with one query
  2. Multiple Updates in MySQL
  3. mysql update column with value from another table
  4. update multiple rows using limit in mysql?
  5. MySQL/SQL: Update with correlated subquery from the updated table itself
  6. What are differences between INSERT and UPDATE in MySQL?
  7. MySql – Way to update portion of a string?
  8. MySQL UPDATE syntax with multiple tables using WHERE clause
  9. The best way to remove value from SET field?
  10. Update MySQL with if condition
  11. Update multiple rows with multiple ‘where’ clauses for each individual row
  12. MySQL update statement to store ranking positions
  13. MySQL – Get row number on select
  14. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  15. How can I tell when a MySQL table was last updated?
  16. SQL Query to get column values that correspond with MAX value of another column?
  17. MySQL : transaction within a stored procedure
  18. When to use SELECT … FOR UPDATE?
  19. Setting column values as column names in the SQL query result
  20. How to get current date & time in MySQL?
  21. Laravel join with 3 Tables
  22. SELECT query return 1 row from each group
  23. MySql Single Table, Select last 7 days and include empty rows
  24. mysql SQL: specific item to be first and then to sort the rest of the items
  25. How to regex in a MySQL query
  26. When is a timestamp (auto) updated?
  27. MySQL Group By Hours
  28. RMySQL dbWriteTable with field.types
  29. Syntax error on MERGE statement
  30. mySQL query to search all tables within a database for a string?

Leave a Comment