Import into database from web

[dagoat10]

Is there a way to import data from another website to mysql
for example stats from another site and import to another site, but continue to import it every hour or so?

 

[r937]

yes, assuming you can generate some kind of file, you would use the LOAD DATA command

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[dagoat10]

so like

Load data
infile '

http://www.site.com'

 

[r937]

um, i think you're going to need a lot more than that

first of all, you will have to go and extract the data you want from that web site somehow, and generate a file

next, you're going to have to expand the LOAD DATA command to (1) identify the table you're loading into, (2) identify the file you've created, and (3) specify where the fields are

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[dagoat10]

ok, i just thought i could read it live

 

[ingresman]

If you want to do it live you could read the site as an HTTP stream and manipulate it in code, then SQL insert to get into the DB