Quick Search:
 
 mySQL: Update and Subtract single query Jump to:  
Category: >> mySQL >> Update and Subtract single query  

<< lastnext >>

Snippet Name: Update and Subtract single query

Description: Simple way to update and add (or subtract) a value to a column.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: February 28th, 2009

UPDATE table_name SET pass = pass-1 
 
--OR
 
UPDATE table_name SET pass = pass+1 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org