Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO tShift1 (tNik, tNama, tDivisi, tSelasa, tTanggal, tShift) SELECT NIK, Nama, Divisi, STATUS, Tanggal, Shift FROM tbESD_Tester WHERE Tanggal = "2020-03-10" AND strftime("%w", Tanggal) = "2" AND Shift = "1"
- ON CONFLICT(tNik)
- DO UPDATE SET tSelasa = excluded.tSelasa, tTanggal = excluded.tTanggal
Add Comment
Please, Sign In to add comment