#1062 - Duplicate entry indexed_field' for key 2
Mysql will return a duplicate entry error when trying to insert a duplicate value in an indexed field in the database. We could modify our sql insert state to check for primary key duplicate or index field duplicate and automatically update the first field with the updated value like this.
INSERT INTO table1 (a,b,c)
SELECT a,b,c
FROM table2
WHERE a IS NOT NULL
ON DUPLICATE KEY
UPDATE table1.a = table2.a
; "Mostly Harmless")
; "Dragonball Evolution Movie")
; "Life the Universe and Everything")
; "The Restaurant at the End of the Universe")
; "the-ultimate-hitchhikers-guide-to-the-galaxy.jpg")
; "Angels And Demons")
; "StarCraft: Brood War")
; "Eagle Eye")
; "Linksys Compact Wireless G USB")
; "We Sing, We Dance, We Steal Things")
u guys are the best!