Datafeed to mysql in the form of csv files

Dunno if this is possible

[malcolmcroucher]

I am downloading a CSV file and then uploading it to mysql .

I am wondering if it is possible to do this in one step to avoid the manual hassle ?

The feed comes in the form :

[website.com...] a bunch of data separated by "+" &f=a bunch of special tags

eg :

[website.com...]

Regards

Malcolm

[rocknbil]

Lots of ways, but you may want to write a small program in perl, php, etc. to customize the import so you get some kind of reporting.

Executing SQL Statements from a Text File [dev.mysql.com] - basically put your commands in a file and run the single command line to use the text file for the actions.

Use mysqlimport [dev.mysql.com] is pretty easy to do too.

Both of these would be much easier if you write a little script that executes them for you.

[malcolmcroucher]

is it possible to do this with ziped files ?

Regards

Malcolm