View Single Post
  #4  
Old 01-12-2004, 05:04 PM
farce
Hill Giant
 
Join Date: Feb 2003
Posts: 126
Default

personally i'd use perl or sed or some such tool, and change all of the INSERT INTO's into REPLACE INTO's..

that way it wont complain about duplicate keys... it'll just replace what's using that key with the last one..

cat foo.sql | sed -e 's/INSERT INTO/REPLACE INTO/' > out.sql

would do it nicely.
Reply With Quote