Set auto increment a value on the fly with MySQL Januari 08, 2020 Set auto increment a value on the fly with MySQL /*Update field Auto Increment*/ SET @num=0; UPDATE r_kab_kota SET id = @num:=@num+1 ORDER BY kab_kota_kode; https://electrictoolbox.com/autoincrement-value-mysql/ Baca selengkapnya