Posted inTech Info
How to update Auto increment value in single column field using a single query
Go to your database ->SQL and add the following query like your table field SET @ordering = 0; UPDATE table SET increment = (@ordering := @ordering + 1) WHERE field…