Update column by decreasing its value by 1 - Cacher Snippet

9/22/2015 - 3:32 PM

Update column by decreasing its value by 1

Update column by decreasing its value by 1

new_gist_file.sql


ref:
http://stackoverflow.com/questions/2834866/increase-and-decrease-row-value-by-1-in-mysql

$sql =  "update coupon set coupon_count=coupon_count-1 where coupon_code = '$discount_coupon'" ;