Re: load data local infile

[nellA hciR]

THANKS!!


that works!

- hcir


> I have had luck by removing the word LOCAL from the statement.
>
> -=Bryan=-
>>
>> from the mysql command line, load data local infile DOES
>> work, am trying to get this to work from Perl
>>
>> $sth = $dbh->prepare("load data local infile
>> '/users/hcir/desktop/t2/0001' into table s0001");
>> $sth->execute() or warn " : $DBI::errstr\n";
>>
>> returns
>> The used command is not allowed with this MySQL version