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
Description: Simple way to update and add (or subtract) a value to a column.
UPDATE table_name SET pass = pass-1 --OR UPDATE table_name SET pass = pass+1