35,10,0,50,1
25,600,60,0,3000,5000,25,800
90,150,1,50,12,30,50,1,70,12,1,50,1,1,1,5000
0,2,1,0,2,40,15,5,2,1,0,20,0,1
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com...
welcome to wplecturer.com...
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com
welcome to wplecturer.com

Translate

duplicate key insert

More
2 weeks 5 days ago #3296 by ekatsa
duplicate key insert was created by ekatsa
When inserting into a table using a select from another table and creating an error with a duplicate key, is it possible to find the value of the key that was duplicated?

Please Log in to join the conversation.

More
2 weeks 5 days ago #3297 by ekatsa
Replied by ekatsa on topic duplicate key insert
better to use a loop likeSTART THE LOOP:
  • read the record
  • check if key exists
  • if not insert
  • if yes write to table PROBLEMATIC_RECS
  • IS THIS LAST RECORD IF YES EXIT
GO TO START THE LOOPDo something like this with PL/SQL or PHP or PRO*C

Please Log in to join the conversation.

Time to create page: 0.218 seconds