Home • Database • MySQL
How to update field increment by 1 in mysql
SET @a = 0; UPDATE item_master set order_by=(@a:=@a+1);
About Author
- University
- Online Tips
- Engineering
- Programming
- General Subjects
- Science
- News
- Jobs
- Commerce
- General Knowledge
- Story, Tales & Poem
- Software Application
- Framework
- Operating System
- Database
- Networking
- Quiz
- Generic ERP
Comments 0