Loading...
This site is best viewed in a modern browser with JavaScript enabled.
Something went wrong while trying to load the full version of this site. Try hard-refreshing this page to fix the error.
INSERT ON DUPLICATE KEY UPDATE
coolman
preserved.
References
https://segmentfault.com/a/1190000017268633
, "MySQL 自增 id 超大问题查询 - 燕南飞和你一起聊技术 - SegmentFault 思否".
https://www.percona.com/blog/2011/11/29/avoiding-auto-increment-holes-on-innodb-with-insert-ignore/
, "Avoiding auto-increment holes on InnoDB with INSERT IGNORE - Percona Database Performance Blog".
https://stackoverflow.com/questions/45778968/mysql-on-duplicate-key-set-last-insert-id-is-causing-auto-increment-to-jump
, "sql - MySql on duplicate key set last_insert_id is causing auto_increment to jump - Stack Overflow".
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_autoinc_lock_mode
, "MySQL :: MySQL 5.7 Reference Manual :: 14.15 InnoDB Startup Options and System Variables".
https://docs.oracle.com/cd/E17952_01/mysql-5.1-en/insert-on-duplicate.html
, "13.2.5.3 INSERT ... ON DUPLICATE KEY UPDATE Syntax".
https://mariadb.com/kb/en/insert-on-duplicate-key-update/
, "INSERT ON DUPLICATE KEY UPDATE - MariaDB Knowledge Base".