merge hostel1 as H1 using hostel2 as H2 on H1.full_name=H2.full_name when matched then update set H1.age=H2.age, H1=fees=H2.fees when not matched by target then insert (room_no,full_name,age,fees,gender,food) values(H1.room,H1.full_name,H1.age,H1.fees,H1.gender,H1.food) when not matched by source then delete;
error I am getting is "Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'merge hostel1 as H1
using hostel2 as H2
on H1.full_name=H2.full_name
when match..' at line 1 0.000 sec"
Asked
Active
Viewed 21 times
0