"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

mysql insert

mysql

How to set initial value and auto increment in MySQL?

mysql insert auto-increment

mysql

Get the new record primary key ID from MySQL insert query?

mysql insert key auto-increment

mysql

How to copy a row and insert in same table with a autoincrement field in MySQL?

mysql sql insert copy

mysql

Escaping single quote in PHP when inserting into MySQL [duplicate]

php mysql insert escaping

mysql

Which is faster: multiple single INSERTs or one multiple-row INSERT?

mysql insert mariadb benchmarking

mysql

Increment a database field by 1

mysql insert increment

mysql

LAST_INSERT_ID() MySQL

mysql insert last-insert-id

mysql

How to do a batch insert in MySQL

mysql sql database insert

mysql

How to insert multiple rows from array using CodeIgniter framework?

php mysql codeigniter insert bulkinsert

mysql

MySql Table Insert if not exist otherwise update

mysql insert

mysql

MySQL Conditional Insert

mysql insert conditional

mysql

Why are 2 rows affected in my `INSERT ... ON DUPLICATE KEY UPDATE`?

mysql insert insert-update

mysql

How to insert data to MySQL having auto incremented primary key?

mysql insert

mysql

What are practical differences between `REPLACE` and `INSERT ... ON DUPLICATE KEY UPDATE` in MySQL?

mysql sql insert replace

mysql