MySQL table primary keys and unique indexes prevent multiple rows with the same index from being added to the table. If you try to insert a duplicate row with a standard INSERT statement, you will ...

INSERT INTO A (COLUMN1, COLUMN2) VALUES ('www.google.com', 10) ON DUPLICATE KEY UPDATE COLUMN2=10; ERROR: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL ...