Update no urut finger otomatis di mysql dengan rumus query

Update master_pgw set NoFinger=Id+50000


Update master_pgw set passw=left(nip,8)