Skip to content

Tag: sql

MYSQL insert into on duplicate key value

I have two tables X and Y. Both of them have the column ‘name’ in common. Columns of X are id(Auto increment) – primary key name email value. Columns of Y are id(Auto increment) – primary key name sex salary There are some rows in X which are not present in Y. I want to insert those mi…