MySQL provides several alternatives to the standard INSERT statement and each handles duplicate rows slightly differently: "INSERT IGNORE," "INSERT ... ON DUPLICATE KEY UPDATE," and "REPLACE." ...

Run your modified query in your SQL browser to view the results. If a duplicate key is found, the query will update the existing column instead of erroring out.