LOAD DATA error

2002-05-03 Thread Julien Calvet 

Hi,

 

 

I Have compile Mysql 3.23.49 with : --enable-local-infile

 

But when I want to use LOAD DATA LOCAL its says : The used command is
not allowed with this MySQL version

 

 

 

Could anyone help me ?

 

Best regards,

 

Julien Calvet


-
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

Re: load data error

2002-02-27 Thread Sommai Fongnamthip 

sorry for my fault:  I forgot $ (dollar sign) before sql variable.

Sommai

At 09:58 28/2/2002 +0700, Sommai Fongnamthip wrote:
>Hi,
> Please tell me why this mysql in php error:
>
>sql = "LOAD DATA LOCAL INFILE \"/home/httpds/htdocs/srg/data/tct.csv\" 
>INTO TABLE tct_temp FIELDS TERMINATED BY '\|'";
>$result = mysql_db_query("$dbName", $sql)
> or die ("Can not run: $sql");
>
> I try another sql style like these
>sql = "LOAD DATA LOCAL INFILE '/home/httpds/htdocs/srg/data/tct.csv' INTO 
>TABLE tct_temp FIELDS TERMINATED BY '\|'";
>
>sql = "LOAD DATA LOCAL INFILE 'data/tct.csv' INTO TABLE tct_temp FIELDS 
>TERMINATED BY '\|'";
>
>
>Thanks
>Sommai
>
>--
>Please be informed that all e-mail which are addressing to
>thaithanakit.co.th will need to be changed to
>BTsecurities.com by March 1, 2002 Thank you. :-)
>--
>
>-
>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

--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 Thank you. :-)
--

-
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

load data error

2002-02-27 Thread Sommai Fongnamthip 

Hi,
Please tell me why this mysql in php error:

sql = "LOAD DATA LOCAL INFILE \"/home/httpds/htdocs/srg/data/tct.csv\" INTO 
TABLE tct_temp FIELDS TERMINATED BY '\|'";
$result = mysql_db_query("$dbName", $sql)
 or die ("Can not run: $sql");

I try another sql style like these
sql = "LOAD DATA LOCAL INFILE '/home/httpds/htdocs/srg/data/tct.csv' INTO 
TABLE tct_temp FIELDS TERMINATED BY '\|'";

sql = "LOAD DATA LOCAL INFILE 'data/tct.csv' INTO TABLE tct_temp FIELDS 
TERMINATED BY '\|'";


Thanks
Sommai

--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 Thank you. :-)
--

-
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