MySQL Forums
Forum List  »  Newbie

importing a web-based txt file into my database
Posted by: BigLee London
Date: July 26, 2005 06:20AM

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

Options: ReplyQuote


Subject
Written By
Posted
importing a web-based txt file into my database
July 26, 2005 06:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.