how to increment integer Columns value by 1 in SQL

My questions is

how to increment a column’s value by 1.

For example, suppose a column ID has values 1,2,3,4, ..

Now when I update this table then ID column should increment by 1,

Now ID will become 2,3,4,5, ..

Leave a Comment