Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
create table Products (
product_id int,
region int,
name varchar(64),
unique key (product_id, region)
);
insert into Products values (10, 20, 'P1020')
on duplicate key update
name = values(name);
insert into Products values (10, 20, 'New Name')
on duplicate key update
name = values(name);
select * from Products;