Jump to content

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


kuma

Recommended Posts

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

 

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.