SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Products (ProductID INT PRIMARY KEY, Product_Name VARCHAR(255) NOT NULL, Cost INT NOT NULL); INSERT INTO Products(ProductID, Product_Name, Cost) VALUES (1,'Parle G',100), (2, 'Maggie', 112), (3, 'GoodDay Biscuit', 150); SELECT * FROM Products; CREATE TABLE Products_Info (ProductID INT PRIMARY KEY, Product_Name VARCHAR(255) NOT NULL, Cost INT NOT NULL); INSERT INTO Products_Info(ProductID, Product_Name, Cost) VALUES(1,'Parle G', 100), (2, 'Maggie', 112), (3, 'GoodDay Biscuit', 115), (4, 'Nestle Coffee', 125), (5, 'TATA Tea', 80); SELECT * FROM Products_Info; MERGE Products t USING Products_Info s ON (s.ProductID = t.ProductID) WHEN MATCHED THEN UPDATE SET t.Product_Name = s.Product_Name, t.Cost = s.Cost WHEN NOT MATCHED BY TARGET THEN INSERT (ProductID, Product_Name,Cost) VALUES(s.ProductID,s.Product_Name,s.Cost) WHEN NOT MATCHED BY SOURCE then delete;