Gossamer Forum
Home : General : Perl Programming :

Import records based on ID, Possible???

Quote Reply
Import records based on ID, Possible???
OK, granted, I'm an idiot.
I've searched, I've read mysql.com, I still can't figure it out.

What I am trying to do is import data from a .txt file into my LinksSQL database based on link.ID. To be specific I want to update the LinkOwner column. I have a .txt file with LinkID and LinkOwner columns but, I can't figure out the sql syntax to update only the LinkOwner column based on ID.
Is this possible?

Any help would be greatly appreciated I have about 600 records I need to update this way.