sql

Increase or decrease column value counter in Mysql

UPDATE table_name 
SET 
column_name = column_name + 1 
WHERE id = 10

The MySql query can be used to increase or decrease a column counter value. As in the code snippet, we have increased cloumn_name value by 1. You can put any value in place of 1.

Was this helpful?

Similar Posts

Reset AUTO_INCREMENT Column value MySql
Add Unique Constraints on Column in MySQL
SQL query to copy one column values to another column in same table
Create or update records Mysql/Sql
MySQL Foreign key constraint
Insert data from one table to another in MySql
Create New User IN MySql

Search all posts...

Programmer's Homepage

Your One-Stop Chrome Extension for Curated Developer Feeds, Where Learning and Growth Never Stop!