tb_as_asset Data Migration

SELECT `sn`, IF(`tipe`='printer',2,IF(`tipe`='scanner',1,IF(`tipe`='switch',4,IF(`tipe`='software',6,IF(`tipe`='wireless',8,IF(`tipe`='handphone',7,99)))))) as tipe, `merk`, `thn_pengadaan`, `garansi`, `vendor`, `kontak_vendor`, `keterangan` FROM `tb_as_device`