one field of my table's field is set to 0 for all rows. but i want to update to incremental value by step 1 in a update query.
how can i do that in mysql?