#1192 (ok 4.4) ON DUPLICATE KEY UPDATE for loading CSV

Needs_decision
fixed
Low
2015-04-20
2010-01-13
Michal Čihař
No

INSERT ... ON DUPLICATE KEY UPDATE is useful when man wants to update table with foreign keys from CSV file. REPLACE won't work in this case as it first deletes the row and then reinserts it, what breaks constraints.

Discussion

  • PHPcian
    PHPcian
    2012-12-25

    Was this feature request worked on?

     
  • Michal Čihař
    Michal Čihař
    2013-01-03

    I don't think anybody is working on this.

     
    • assigned_to: Madhura Jayaratne
    • Group: --> Needs_decision
     
    • summary: ON DUPLICATE KEY UPDATE for loading CSV --> (ok 4.4) ON DUPLICATE KEY UPDATE for loading CSV
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle
    Marc Delisle
    2015-02-15

    • Priority: 1 --> Normal
     
  • Marc Delisle
    Marc Delisle
    2015-02-15

    • Priority: Normal --> Low
     
  • Marc Delisle
    Marc Delisle
    2015-04-20

    • Status: resolved --> fixed