Codes here !
Moderators: macek, egami, gesf
- php-forum Fan User
- Posts: 594
- Joined: Fri Aug 05, 2011 9:53 am
I've seen things like
Code: Select all
INSERT INTO moviedb.genre (GenreID,GenreName)
VALUES ('18', 'Drama'),
ON DUPLICATE KEY UPDATE
GenreName = VALUES(GenreName);
Try using the values() part where you want to set the value of the updated field.
Also as sim_name is probably your primary key - you don't need that in your update part.
Who is online
Users browsing this forum: No registered users and 2 guests