Feeding data into MySQLdb LOAD DATA from Python
John Nagle
nagle at animats.com
Wed Nov 14 14:09:15 EST 2007
Is it possible to feed data into a LOAD DATA command in MySQL without
writing out the data to a file? It's possible to do this using the
MySQL command line and a UNIX FIFO, but that's kind of clunky.
I have to load a few gigabytes of data, and using INSERT takes
a whole day for each update.
And can this be done portably across UNIX and Windows? Thanks.
John Nagle
More information about the Python-list
mailing list