i have a one question for increment +1 in every row i have a sql table in that table have order_status column when new record created order_status will be store +1 then older record in that case if i have order status like 0 1 2 3 but when user send me order status 2 for 5th record so in this case record no 5 will be store as a record status 2 but i need to change status aftr 2 like
2 will be 3, 3 will be 4, 4 will be 5
if its posible so please me sql query
Use an UPDATE query.
UPDATE yourTable
SET order_status = order_status + 1
WHERE order_status >= 2