Hi Guys,
Lets say I have a text file at www.mydomain.com/myfile.txt
i want to import it into my mysql db as this txt file is structured like so:
| 25 18 | 1.7 1 | 1.7 7.7 109 |
| 25 19 | 1.6 1 | 1.6 7.7 109 |
| 25 20 | 1.6 1 | 1.6 7.7 109 |
eventually i'll be using the first column as unique id and then be able to read the other 2 columns content and relate it to the first.
Now someone said to try this:
http://dev.mysql.com/doc/mysql/en/load-data.html
but the file name is not a url.
Can anyone suggest any way that i can import this file and in such a way that i can read out each value in each column seperately (so its not the case of just dumpnig the whole whole in a field)
I hope this makes sense,
thanks in advance for all your help.
BigLee