CODEWITHSUNDEEP
mysqlloadperformance
Tim Specht
Tim Specht

Reputation: 3218

MYSQL Bulk "INSERT ... ON DUPLICATE KEY UPDATE ..." via "LOAD DATA INFILE"

Hej,

I need to mass-update a table. Am I allowed to use mysql's "LOAD DATA INFILE" Statement together with "INSERT … ON DUPLICATE KEY UPDATE" statements to fulfill my task?

Upvotes: 0

Views: 6145

Answers (1)

Ike Walker
Ike Walker

Reputation: 65537

Depending on your exact requirements, you may be able to accomplish this using the REPLACE option of LOAD DATA INFILE. From the manual:

  • If you specify REPLACE, input rows replace existing rows. In other words, rows that have the same value for a primary key or unique index as an existing row. See Section 12.2.7, “REPLACE Syntax”.

Example:

LOAD DATA INFILE '/tmp/data.txt'
REPLACE INTO TABLE your_table
(column1, column2, ...)

Upvotes: 3

Related Questions