Hi all,
Don't know if this is the right spot for this, but I thought I'd try.
I'm facing an issue, that someone with some SQL knowledge can figure out just by looking at it.
I managed to receive some daily logging, and would like some statistics generated out of them.
What I managed to do... Write a VB script to;
a) Copy the logs , and extract the content (it's a compressed GZ file).
b) Create an SQL file that;
b 1) creates a seperate database-table for each (csv) log file,
b 2) import the extracted CSV file into the database-table.
c) Execute the SQL file on the MySQL-commandline.
Here is a simple representation of layout of such table (1 table per day, being called something like AB_20121010, AB_20121011, AB_20121012 <-- See
how these numbers are the date YYYY MM DD)
Now I've been trying to figure out;
1) How to populate a table called "statistics_a" with the following information
2) How to populate a table called "statistics_b" with the following information
Would be great, if this could be done in said SQL file, and not some PHP queries or something.
But I can't seem to figure it out :S
Any tips, highly appreciated.