Notifications
Clear all
Topic starter 18/10/2024 6:45 pm
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?
Topic starter 18/10/2024 6:45 pm
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
Forum Statistics
66 Forums
2,053 Topics
4,277 Posts
0 Online
2 Members
Latest Post: What about LearnDash LMS ? Our newest member: Elias Recent Posts Unread Posts
