MySQL Update Column 1

Question

I was wondering what would be the easiest way to update a column by  1  I will be updating a post count of a category based on when users submits a new post   Thanks

User · Answer

You can do   UPDATE categories SET posts   posts   1 WHERE category id   42

User · Answer

update post set count   count   1 where id   101

User · Answer

The easiest way is to not store the count  relying on the COUNT aggregate function to reflect the value as it is in the database      SELECT c category name            COUNT p post id  AS num posts      FROM CATEGORY c LEFT JOIN POSTS p ON p category id   c category id   You can create a view to house the query mentioned above  so you can query the view just like you would a table     But if you re set on storing the number  use   UPDATE CATEGORY    SET count   count   1  WHERE category id         replacing     with the appropriate value

User · Answer

How about   update table set columnname   columnname   1 where id    lt some id gt

User · Answer

update table name set field1   field1   1

User · Answer

update TABLENAME set COLUMNNAME   COLUMNNAME   1 where id    YOURID

[mysql] MySQL Update Column +1?

Examples related to mysql

Examples related to sql

Examples related to sql-update

Examples related to aggregate-functions