Home  • Database • MySQL

How to update field increment by 1 in mysql

SET @a = 0;
UPDATE item_master set order_by=(@a:=@a+1);

Comments 0


Share

Copyright © 2024. Powered by Intellect Software Ltd