MySQL Forums
Forum List  »  Perl

Advanced Search
New Topic

Re: Make data load infile more tolerant. Works in SQLyog
Posted by: Paul Beerkens
Date: April 03, 2007 12:54PM

I found the solution using the useful general log (switched on by specifying --log as a command line paramater to mysqld).

Add
$dbh->do ("set sql_mode=''");
to your code.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Make data load infile more tolerant. Works in SQLyog
Paul Beerkens
April 03, 2007 07:31AM
Re: Make data load infile more tolerant. Works in SQLyog
Paul Beerkens
April 03, 2007 12:54PM


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.