File I/O And Registry :: Reading A Textfile And Sorting Things Out?

I have a txt file, that i want to read into my program. The problem is this:The textfile is a stats file for a game and looks like this:

Code:
ip:port wins username points
ip:port wins username points
ip:port wins username points
ip:port wins username points
ip:port wins username points
etc.

The main thing i want to do is sort these things out and then add to mysql database table that would have these columns:

Code:
ip authid wins username points

So what i wanna do is splitting this textfile data up and then adding everything to a mysql table.