sql query to modify the selected value from database [closed]

by 

update table1 set numberfield = numberfield - 7

if numberfield is 30, then numberfield = 30 – 7, difference will be the new value of the field

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. Calculate Average of the largest values in multiple columns
  3. SQL Print the name of all Employees together with the name of their supervisor
  4. Storing JSON in database vs. having a new column for each key
  5. SQL: Repeat a result row multiple times, and number the rows
  6. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  7. Why do results from a SQL query not come back in the order I expect?
  8. When to use SELECT … FOR UPDATE?
  9. Best practices for SQL varchar column length [closed]
  10. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  11. how to cast the hexadecimal to varchar(datetime)?
  12. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  13. Why in SQL NULL can’t match with NULL?
  14. Convert SQL Server query to MySQL [duplicate]
  15. comparison of truncate vs delete in mysql/sqlserver [duplicate]
  16. Column calculated from another column?
  17. Error in MySQL when setting default value for DATE or DATETIME
  18. How does MySQL process ORDER BY and LIMIT in a query?
  19. sql join two table
  20. Is there a Profiler equivalent for MySql? [closed]
  21. Cast int to varchar
  22. Import SQL file into mysql
  23. How to export data from SQL Server 2005 to MySQL [closed]
  24. MySQL SELECT last few days?
  25. “where 1=1” statement [duplicate]
  26. How to migrate SQL Server database to MySQL? [closed]
  27. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  28. Postgres LEFT JOIN with WHERE condition
  29. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  30. SQL query with avg and group by

Leave a Comment