5 messages in com.mysql.lists.win32RE: Can't Load CSV data into Mysql us...| From | Sent On | Attachments |
|---|---|---|
| Jack | 24 Apr 2002 05:32 | |
| Nick Bergquist | 24 Apr 2002 06:07 | |
| Dave Watkinson | 24 Apr 2002 06:23 | |
| Fredrick Bartlett | 24 Apr 2002 07:33 | |
| Jack | 24 Apr 2002 22:04 |
| Subject: | RE: Can't Load CSV data into Mysql using "LOAD DATA LOCAL INFILE" |
|---|---|
| From: | Nick Bergquist (ni...@londonfreemasonry.com) |
| Date: | 04/24/2002 06:07:26 AM |
| List: | com.mysql.lists.win32 |
Hi Jack,
Someone else on the list is no doubt better informed as to why, but I`ve had similar problems just lately although I don`t use the GUI. I got round it by leaving the 'local' off when importing tab-delimited data locally (i.e., from my workstation into MySQL running on the same workstation). Having said that, the string `as is` worked fine when importing data from a text file on our remote server. Another problem that you may be having is that the text file cannot be found. Try saving it in the actual database directory first...
Hope this helps ;-)
-- Nick Bergquist Web developer - London Management http://www.londonfreemasonry.com n.be...@londonfreemasonry.com Tel. +44 (0)20 7539 2934
-----Original Message----- From: Jack [mailto:nedc...@nedcor.com.hk] Sent: 24 April 2002 13:33 To: win...@lists.mysql.com Subject: Can't Load CSV data into Mysql using "LOAD DATA LOCAL INFILE"
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 nedc...@nedcor.com.hk
--------------------------------------------------------------------- Please check
"http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.