Geek asks and answers

How no-op if a duplicate key exception occurs?

I know that I can use ON DUPLICATE KEY UPDATEand then perform a no-op operation in MySQL if a duplication exception occurs, but is there a more efficient way?

+3
source share
2 answers
INSERT IGNORE INTO tableName ....

see Documents

+1
source

Although true, I found that execution INSERT IGNOREcreates holes in your auto-increment identifiers. In particular, if you execute INSERT IGNORE, and it encounters the current row, the data is not written (what you need), BUT the auto_increment value for this table is increased by one.

, , . . - :

INSERT INTO TABLE (column list) VALUES (value list) ON DUPLICATE KEY UPDATE random_column = random_column

no-op. , , .

+1

More articles:


All Articles