I am trying to merge two tables (studenttarget and studentsource). However, when I execute the following SQL in MySQL Workbench, I receive the error "''Merge' (merge) is not valid input at this position." This video (https://www.youtube.com/watch?v=5dk33HN8BX8) got this code to work in SQL Server (@ 7:02 mark) whereas I am using MySQL. Could this be the issue? Is there a better way to go about this? Thanks in advance!
MERGE test.studenttarget AS T
USING test.studentsource as S
ON T.ID = S.ID
WHEN MATCHED THEN
UPDATE SET T.Name = S.Name
WHEN NOT MATCHED BY TARGET THEN
INSERT (ID, Name) Values (S.ID, S.Name)
