[SOLVED] Update some (not all) records with tab delimited file (possible?)

[kuma]

I have a table with an id and name field and a tab-delimited file with an id field and new names for some of the records.

 

Here's my attempt, which works:

 

USE databaseName

 

CREATE TABLE shopsTemp (

        id INT,

        name VARCHAR (100));

LOAD DATA LOCAL INFILE '/home/user/updateNames.txt'

        INTO TABLE shopsTemp;

 

# Replace stores in original table with updated names

UPDATE shops, shopsTemp

        SET shops.name = shopsTemp.name

        WHERE shops.id = shopsTemp.id;

 

# Remove temp table

DROP TABLE shopsTemp;

 

My question is, can I use some kind of update statement instead of creating a new table and then deleting it? All the update examples I've seen are for just a few records - I haven't come across an example where update data is read in from a file. Thank you for any help!

 

MySQL Server version: 5.0.37

 

 

[fenway]

Why not access the CSV file as a table directly? There's a CSV engine type.

[kuma]

Thank you very much, just what I was looking for.

 

http://dev.mysql.com/tech-resources/articles/csv-storage-engine.html