week35-review.md

mysql-insert-ignore [R2]

• However, if you use the INSERT IGNORE statement, the rows with invalid data that cause the error are ignored and the rows with valid data are inserted into the table.

• MySQL truncated data before inserting it into the tokens table

http://www.mysqltutorial.org/mysql-insert-ignore/

“INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”

I would recommend using INSERT...ON DUPLICATE KEY UPDATE.

https://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update

在InnoDB中使用INSERT IGNORE来避免自动递增的漏洞

https://www.oschina.net/question/207055_33444

自增锁引发的悲剧

• 和auto_increment相关的insert种类

1. INSERT-like
2. simple insert
3. Bulk inserts
4. Mixed-mode inserts

https://keithlan.github.io/2017/03/03/auto_increment_lock/

InnoDB AUTO_INCREMENT Lock Modes

Q: Tx2的自增id有3种可能的情况,Tx2 > Tx1 // Tx2< Tx1 // minTx1<Tx2<Tx1max，是哪种?

Tx1: INSERT INTO t1 (c2) SELECT 1000 rows from another table ...
Tx2: INSERT INTO t1 (c2) VALUES ('xxx');

https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html#innodb-auto-increment-lock-modes