update with increment value | java php laravel linux mysql sql bootstrap html css query java php laravel linux mysql sql bootstrap html css query: update with increment value

Wednesday, October 3, 2018

update with increment value

SELECT @i:=0;

UPDATE ijazah SET no_urut = @i:=@i+1 ORDER BY nim;

select * from ijazah

No comments:

Post a Comment

saifiahmada.com adalah blog belajar programming Indonesia, membahas lengkap materi bahasa pemrograman: code HTML, CSS, Bootstrap, Desain, PHP, MySQL, coding Java, Query, SQL, dan dunia linux