Search Results

no worries i worked it out - the mysqlimport options do work, i just got --fields-terminated-by=" wrong. I had to play around with this to get it to work

absolutely :)

here is one line of delimited info:


"product name"|"http://example.com/productlink.htm"|"http://example.com/productimage.jpg"|"price $80"


The code I am sending to mysql...

Hi,

Im a pretty large noob to linux/perl etc and im trying to use mysql slurp to take a delimited file and import it into mysql using stdin (in the hope its faster)
mysqlslurp - slurp <STDIN>...