How to find bad row with db api executemany()? (PS)
Tim Chase
python.list at tim.thechases.com
Fri Mar 29 23:38:08 EDT 2013
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
More information about the Python-list
mailing list