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
