Jump to content

Archived

This topic is now archived and is closed to further replies.

shai1

batch insert from external file

Recommended Posts

A while back I thought I read of a way to insert records from an external file without having to "loop" through them. I've been looking for how to do this and of course now I can't find it again. If anyone could show me an example of how to do this I would really appreciate it.

Thanks,
Dave

Share this post


Link to post
Share on other sites
I found what I was looking for...

[b]Load data infile[/b]. I thought I would post it for others to learn from. When searching I was looking for [b]insert from file[/b] and that is why I couldn't find any information on it. I have not tried it yet, but I've read that it is very fast.

Thanks,
Dave

Share this post


Link to post
Share on other sites
It is incredibly fast... in fact, it's probably the best way to import data into a MySQL table.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.