The Underscore Archives

> I use SQLyog Enterprise

I was a luddite CLI only mysql user for years but over the past 12
months has moved over to use SQL Yog exclusively, it's a great tool,

With regards to the OP: I've use load data infile with great success
for huge CSVs in the past, it's suprisingly speedy too. Where there is
a post-processing need like yours I'd create a temp table and simply
dump everything in there raw then use a bespoke php/mysql script to
split it out to the relevant tables, sanitising as I go.

db

-- 
Darren Beale
07711 716 197

http://bealers.com