kuma Posted December 3, 2007 Share Posted December 3, 2007 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 Link to comment https://forums.phpfreaks.com/topic/80007-solved-update-some-not-all-records-with-tab-delimited-file-possible/ Share on other sites More sharing options...
fenway Posted December 3, 2007 Share Posted December 3, 2007 Why not access the CSV file as a table directly? There's a CSV engine type. Link to comment https://forums.phpfreaks.com/topic/80007-solved-update-some-not-all-records-with-tab-delimited-file-possible/#findComment-405347 Share on other sites More sharing options...
kuma Posted December 3, 2007 Author Share Posted December 3, 2007 Thank you very much, just what I was looking for. http://dev.mysql.com/tech-resources/articles/csv-storage-engine.html Link to comment https://forums.phpfreaks.com/topic/80007-solved-update-some-not-all-records-with-tab-delimited-file-possible/#findComment-405363 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.