MySQL Forums
Forum List  »  PHP

Re: single quote in data breaks file load
Posted by: Steve Szmidt
Date: July 26, 2005 07:12PM

Roland Bouman wrote:

> btw, If you have the chance of unsing the LOAD
> DATA INFILE syntax instead (as opposed to handling
> it yourself in php), I would certainly try that.
> It's bound to be much faster than this. See the
> mysql reference or details.

Yeah, but I only run this script once a day, and it processes 32,000 rec's in a few sec, so It's OK for now. But thanks for the tip anyway! : )

Now I'm going to look into your code and see how that works, thanks!

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.