phpMyAdmin / Feature Requests / #1192 (ok 4.4) ON DUPLICATE KEY UPDATE for loading CSV

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

Milestone: Needs_decision

Status: fixed

Owner: Madhura Jayaratne

Labels: Interface Improvements (356)

Priority: Low

Updated: 2015-04-20

Created: 2010-01-13

Creator: Michal Čihař

Private: 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 - 2012-12-25

Was this feature request worked on?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michal Čihař - 2013-01-03

I don't think anybody is working on this.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-02-06

assigned_to: Madhura Jayaratne

Group: --> Needs_decision
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-02-06

summary: ON DUPLICATE KEY UPDATE for loading CSV --> (ok 4.4) ON DUPLICATE KEY UPDATE for loading CSV

status: open --> resolved

Priority: 5 --> 1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-02-06

Implemented with https://github.com/phpmyadmin/phpmyadmin/commit/6f9367b1652e6b5cee652ab4729bb0253ac74b95

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2015-02-15

Priority: 1 --> Normal
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2015-02-15

Priority: Normal --> Low
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Delisle - 2015-04-20

Status: resolved --> fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

(ok 4.4) ON DUPLICATE KEY UPDATE for loading CSV

A software tool to bring MySQL to the Web

Group

Searches

Help

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

Discussion