Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nhatto
Starting Member
2 Posts |
 Posted - 2009-11-12 : 16:45:20
|
trying to import a csv file to an sql database.the file is located on the server, but i dont know how to point to that locationmy code is : LOAD DATA LOCAL INFILE '/tmp/phpQF37Dj' INTO TABLE [...] LINES TERMINATED BY '\r\n'# Affected rows: 301508 where is /tmp/phpQF37Dj on the server?and how i replace it with another path?i tried /home/file.csvi tried other things too.. but non worked.I am only using cpanel and an ftp program |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
where is tmp/