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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
