Can't Load Data into Mysql Using "LOAD DATA"
| From: | Jack | Date: | Wed, 24 Apr 2002 08:19:12 +0000 |
| Subject: | Can't Load Data into Mysql Using "LOAD DATA" | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-94326@lists.php.net to get a copy of this message | ||
Dear all
I'm trying to load data from a test.csv file into myql database, but it
seems the data didn't get into the table!!
I use a GUI Program which i type in the Mysql Command to it and execute it,
so i type in the following command :
"Load Data Local infile 'c:\test.csv' into to table testdeposite lines
terminated by ","
it shows the command had successfully executed, by when i type "select *
from testdeposite" which want to check if the data is successfully inserted,
it say no record exist in table!
Could someone pls tell me what happen here?
--
Thx a lot!
Jack
nedcor4@nedcor.com.hk