shai1 Posted October 9, 2006 Share Posted October 9, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/23478-batch-insert-from-external-file/ Share on other sites More sharing options...
shai1 Posted October 10, 2006 Author Share Posted October 10, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/23478-batch-insert-from-external-file/#findComment-106610 Share on other sites More sharing options...
fenway Posted October 10, 2006 Share Posted October 10, 2006 It is incredibly fast... in fact, it's probably the best way to import data into a MySQL table. Quote Link to comment https://forums.phpfreaks.com/topic/23478-batch-insert-from-external-file/#findComment-106887 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.