CODEWITHSUNDEEP
mysqlsql
Mr. Shrestha
Mr. Shrestha

Reputation: 102

How to increase the value of column by 1 in mysql or phpmyadmin?

I want to increment a field value by (+1) in every row of mysql table.

How to do that using mysql or phpmyadmin?

Upvotes: 1

Views: 5900

Answers (2)

Ofir Winegarten
Ofir Winegarten

Reputation: 9365

update my_table set my_field = my_field+1

Upvotes: 6

ScaisEdge
ScaisEdge

Reputation: 133370

You can use an update eg:

update my_table  
set my_column  = my_column +1

Upvotes: 5

Related Questions