Pathologically Eclectic Rubbish Lister | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Somewhat scared to enter this heated conversation, I'll try not to leave too large a footprint.
My suggestion is to clean it up like this: -Adam
Since the insert would fail on a duplicate, I assume you already have a primary column determined, so a replace would seem to be the best - it almost identically follows insert syntax (at least in MySQL, which, I have to admit, is the only SQL db I've ever used). Hope this helps, In reply to Re: Updating or Inserting a database from a txt file
by Adrade
|
|