Update MySQL with if condition

by

MySQL supports IF statement.

UPDATE  abbonamento
SET     punti = IF(tipo = 'punti', punti - 1, punti),
        bonus = IF(tipo <> 'punti', bonus - 1, bonus)
WHERE   id = 17

or you can also use CASE

UPDATE  abbonamento
SET     punti = CASE WHEN tipo = 'punti' THEN punti - 1 ELSE punti END,
        bonus = CASE WHEN tipo <> 'punti' THEN bonus - 1 ELSE bonus END
WHERE   id = 17

More Related Contents:

  1. MySQL, update multiple tables with one query
  2. UPDATE multiple rows with different values in one query in MySQL
  3. Multiple Updates in MySQL
  4. mysql update column with value from another table
  5. update multiple rows using limit in mysql?
  6. MySQL/SQL: Update with correlated subquery from the updated table itself
  7. What are differences between INSERT and UPDATE in MySQL?
  8. MySql – Way to update portion of a string?
  9. MySQL UPDATE syntax with multiple tables using WHERE clause
  10. The best way to remove value from SET field?
  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. How can I tell when a MySQL table was last updated?
  15. Operand Should Contain 1 Column – MySQL NOT IN
  16. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  17. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  18. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  19. Determine Rank based on Multiple Columns in MySQL
  20. What is better in MYSQL count(*) or count(1)?
  21. Best practices for SQL varchar column length [closed]
  22. How to get the count of each distinct value in a column? [duplicate]
  23. How to enable INNODB in mysql
  24. Bash script to insert values in MySQL
  25. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  26. How do I lag columns in MySQL?
  27. How to get multiple records against one record based on relation?
  28. SQL query to check if a name begins and ends with a vowel
  29. How to use a user variables in MySQL LIKE clause?
  30. MySQL: Computed Column

Leave a Comment