mysql中merge into

MERGE INTO target_table AS TGT
USING source_table AS SRC
ON TGT.matching_column = SRC.matching_column
WHEN MATCHED THEN
    UPDATE SET TGT.column1 = SRC.column1, TGT.column2 = SRC.column2, ...
    [DELETE WHERE condition]
WHEN NOT MATCHED THEN
    INSERT (column1, column2, ...)
    VALUES (SRC.column1, SRC.column2, ...);

CREATE TABLE target_table (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

CREATE TABLE source_table (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

MERGE INTO target_table AS TGT
USING source_table AS SRC
ON TGT.id = SRC.id
WHEN MATCHED THEN
    UPDATE SET TGT.name = SRC.name, TGT.age = SRC.age
WHEN NOT MATCHED THEN
    INSERT (id, name, age)
    VALUES (SRC.id, SRC.name, SRC.age);