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

On Wednesday 24 April 2002 16:19, Jack wrote: > 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? Dunno. Maybe you posted to the wrong list. The mysql list is what you want. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Nezvannyi gost'--khuzhe tatarina. [An uninvited guest is worse than the Mongol invasion] -- Russian proverb */