update a column by subtracting a value

by 
UPDATE a75ting.username
SET points = points - 5

by putting the single quotes around the “points -5”, you converted that expression into a plaintext string. Leaving it without the quotes lets MySQL see you’re referring to a field (points) and subtracting 5 from its current value.

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. In SQL Server how to get the count of child if both parent and child are available [closed]
  3. Delete the entire content of all table in a Database [closed]
  4. MySQL select 10 random rows from 600K rows fast
  5. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  6. Get a list of dates between two dates
  7. Calculate a running total in MySQL
  8. Simulate lag function in MySQL
  9. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  10. Get record counts for all tables in MySQL database
  11. MySQL – Operand should contain 1 column(s)
  12. How to get the difference in years from two different dates?
  13. Restore table structure from frm and ibd files
  14. mysql pivot/crosstab query
  15. Use MySQL spatial extensions to select points inside circle
  16. UNION query with codeigniter’s active record pattern
  17. INSERT … ON DUPLICATE KEY (do nothing)
  18. MySQL create stored procedure syntax with delimiter
  19. Mysql Convert Column to row (Pivot table )
  20. Merge two tables in one SQL query and make the date values unique
  21. How to find non-existing data from another Table by JOIN?
  22. MySQL/SQL: Update with correlated subquery from the updated table itself
  23. Mysql insert random datetime in a given datetime range
  24. Greatest value of multiple columns with column name?
  25. MySQL UPDATE syntax with multiple tables using WHERE clause
  26. Are SELECT type queries the only type that can be nested?
  27. Strings as Primary Keys in MYSQL Database [closed]
  28. MySQL OPTIMIZE all tables?
  29. Strip last two characters of a column in MySQL
  30. Deleting a row based on the max value

Leave a Comment