Code: Select all
INSERT INTO moviedb.genre (GenreID,GenreName)
VALUES ('18', 'Drama'),
('16', 'Animation')
ON DUPLICATE KEY UPDATE
GenreName = VALUES(GenreName);
Also as sim_name is probably your primary key - you don't need that in your update part.