Hi:
I had a problem with one field, which I edited in a text editor, and now I am ready to put it back. My file looks like this:
ID|CREW
ID2|Crew2
etc...
So, what I wanted to do was import the new "Crew" fields, replacing the OLD ones, but not touch any of the other data. I tried the Import in MySQLMan, and it either does NOTHING, or erases all the data when it inserts the new data.
I tried to do it directly, like this:
LOAD DATA INFILE '/home/c/cartoon/public_html/rr.txt' INTO TABLE Links FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 0 LINES (ID,Crew)
and get the samew results.
What is the "proper" way to insert (replace!) just one field?
Thanks!
dave
Big Cartoon DataBase
Big Comic Book DataBase
I had a problem with one field, which I edited in a text editor, and now I am ready to put it back. My file looks like this:
ID|CREW
ID2|Crew2
etc...
So, what I wanted to do was import the new "Crew" fields, replacing the OLD ones, but not touch any of the other data. I tried the Import in MySQLMan, and it either does NOTHING, or erases all the data when it inserts the new data.
I tried to do it directly, like this:
LOAD DATA INFILE '/home/c/cartoon/public_html/rr.txt' INTO TABLE Links FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 0 LINES (ID,Crew)
and get the samew results.
What is the "proper" way to insert (replace!) just one field?
Thanks!
dave
Big Cartoon DataBase
Big Comic Book DataBase