I found this :
INSERT .... ON DUPLICATE KEY ...
What does 'ON DUPLICATE' mean ?
It means that it will execute that action, when you are trying to insert a new record with a primary key that already exists.
IF you want to find more info about those keywords such as ON DUPLICATE, CASCADE, AFTER INSERT , BEFORE INSERT. You always refer to Oracle web site. There is so much info.
Good Luck. Please mark the thread as solved. Thanks.
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.