What is the meaning of ON DUPLICATE

[begueradj]

Hello

I found this :

INSERT .... ON DUPLICATE KEY ...

What does'ON DUPLICATE' mean ?

Thank you

[pritaeas]

It means that it will execute that action, when you are trying to insert a new record with a primary key that already exists.

[rotten69]

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.