Blog Andri Wiratmono

Pagut Asri Blok D No.2 - Kelurahan Blabak - Pesantren Kota Kediri

back

Sintak Update Postgresql Database Feeder PDDIKTI

17 Oktober 2017 || 22:55:08 WIB || ClassyID

Buat catatan pribadi saja :

UPDATE 
kuliah_mhs_coba
SET 
ipk=akm_coba.ipk,
sks_smt=akm_coba.sks_smt,
sks_total=akm_coba.sks_total,
last_update=akm_coba.last_update,
last_sync=akm_coba.last_sync,
csf=akm_coba.csf
FROM
akm_coba
WHERE kuliah_mhs_coba.id_smt=akm_coba.id_smt
AND kuliah_mhs_coba.id_reg_pd=akm_coba.id_reg_pd ;