Member Avatar for begueradj

Hello

I found this :

INSERT .... ON DUPLICATE KEY ...

What does 'ON DUPLICATE' mean ?

Thank you

  • 3 Contributors
  • 2 Replies
  • 66 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by rotten69
Member Avatar for 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.

Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.