query mysql in php to get the difference between two tables

Question

I have two tables with the same structure to get users finger print data and i want to get from the first table data that is not exist in the second table and insert it into the second table the structure of two tables:

• ID
• USER_ID
• check_time
• check_type
• sensor_id

Answer 1

You can use insert into select from using some additional join as

insert into table2 
select 
t1.* from table1 t1
left join table2 t2 on t1.user_id = t2.user_id and t1.check_time = t2.check_time
where t2.user_id is null and t2.check_time is null