Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question