duplicate record
- by user349953
Insert into Attendancemst
( emp_code , name, date , timetable , on_duty,out_duty,clockin , clockout,
late, early, mis_in , mis_out , absent , halfday, total_time
)
values
(pemp_code,pname,pdate,ptimetable,pon_duty,pout_duty ,pclockin,pclockout,plate,
pearly, pmis_in,pmis_out,pabsent,phalfday,ptotal_time
)ON DUPLICATE KEY UPDATE emp_code=pemp_code and date = pdate;
