Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import SOME fields into Links

Quote Reply
Import SOME fields into Links
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