Can't Load Data into Mysql Using "LOAD DATA"

From: 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

« previous php.general (#94326) next »