Magic2K2
July 26th, 2001, 08:29
I am attempting to load some stats into my database using the LOAD DATA INFILE command. However, I do not want to load all the fields from http://sports.yahoo.com/nbastats/regular_season.txt
I would like to skip about 8 of those fields that I don't need in my database. Does anybody have a solution? I have considered loading all the data into a temp table and then copying over what I need, but that would still require a bunch of Insert statements that I am trying to avoid. So, even if you don't have a perfect solution, if it can just avoid excessive Inserts, I'd be happy. Thanks.
I would like to skip about 8 of those fields that I don't need in my database. Does anybody have a solution? I have considered loading all the data into a temp table and then copying over what I need, but that would still require a bunch of Insert statements that I am trying to avoid. So, even if you don't have a perfect solution, if it can just avoid excessive Inserts, I'd be happy. Thanks.