<div>
This will be complex to do through phpMyAdmin.<br />
<br />
In fact, using .csv file data for UPDATEs rather than INSERTs is complex. I don't thing there's no real native support for this.<br />
<br />
Likely you'll have to write a script to ingest your .csv data + build a .sql file doing each UPDATE, then ingest your .sql file into phpMyAdmin.
</div>


This will be complex to do through phpMyAdmin.

In fact, using .csv file data for UPDATEs rather than INSERTs is complex. I don't thing there's no real native support for this.

Likely you'll have to write a script to ingest your .csv data + build a .sql file doing each UPDATE, then ingest your .sql file into phpMyAdmin.

Tech

doctorbill

<div>
I am not quiet sure about this but I wanted to try with <a href="http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server" rel="ugc">LOAD DATA INFILE</a>. As I get chance to test it, I'd post here. Mostly load-data for column two and write col2 as SET col2=...
</div>


I am not quiet sure about this but I wanted to try with LOAD DATA INFILE [http://kedar.nitty-witty.com/blog/load-delimited-data-csv-excel-into-mysql-server]. As I get chance to test it, I'd post here. Mostly load-data for column two and write col2 as SET col2=...

<div>
I have managed to get it working with Navicat<br />
Thanks all
</div>


I have managed to get it working with Navicat
Thanks all

<div>
<div class="content wysiwyg-content">
MySQL table column names:<br />
<br />
column1, column2, column3<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3<br />
<br />
<br />
a CSV file has these columns names and new values<br />
I just want to update column2 for the time being with new values<br />
I would also like to be able to either update existing values or add (append) new ones to this column2<br />
I use phpmyadmin
</div>
</div>


MySQL table column names:

column1, column2, column3
1                1               1
2                2               3


a CSV file has these columns names and new values
I just want to update column2 for the time being with new values
I would also like to be able to either update existing values or add (append) new ones to this column2
I use phpmyadmin

update records with csv file

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.