I
I
Ivan Ilyasov2018-10-03 23:07:47
MySQL
Ivan Ilyasov, 2018-10-03 23:07:47

How to import (update) data of only one or two specific columns in a table via csv file?

Given :
There is a table with several columns. Say: id_order | date | qty | order_state | what_to | i_td
There is a csv file with two columns:
id_order | order_state
1 | 22
2 | 7
3 | 15
5 | 22
etc.
id_order - primary key (primary or whatever )
Task :
Replace (update) the data of these two columns only. How?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
AVKor, 2018-10-04
@AVKor

Parse on any PL, update the database with the received data.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question