On 2013-03-29 22:17, Tim Chase wrote: > 2) Load into a temp table in testable batches, then do some sort of > batch insert into your main table. Again, a quick google suggest > the "INSERT ... SELECT" syntax[2]
It looks like there's a corresponding "REPLACE INTO ... SELECT" syntax[1], as you mention doing a REPLACE INTO rather than a straight INSERT -tkc [1] http://dev.mysql.com/doc/refman/5.0/en/replace.html -- http://mail.python.org/mailman/listinfo/python-list