brent_weaver Guru
Joined: 01 Jul 2004 Posts: 510 Location: Burlington, VT
|
Posted: Thu Apr 03, 2014 11:43 am Post subject: Nomalizing MySQL Data |
|
|
Hey there... I have all these cdv flat files I would like to load into a mysql db. The look like this:
Code: | upha,cache2008,01/01/14,01/05/14,upha
Date,Weekday,Timestamp,cache (Max 600),IDX00659 (Max 600),IDX00660 (Max 600)
01/01/14,Wednesday,12:00 AM,41,1,3
01/01/14,Wednesday,12:15 AM,40,1,1
01/01/14,Wednesday,12:30 AM,39,1,1
01/01/14,Wednesday,12:45 AM,39,0,0
01/01/14,Wednesday, 1:00 AM,39,0,0
01/01/14,Wednesday, 1:16 AM,47,0,0
01/01/14,Wednesday, 1:30 AM,39,0,0
01/01/14,Wednesday, 1:45 AM,39,0,0
01/01/14,Wednesday, 2:01 AM,39,0,0
01/01/14,Wednesday, 2:15 AM,39,0,0
01/01/14,Wednesday, 2:30 AM,39,0,0
01/01/14,Wednesday, 2:45 AM,39,0,0
01/01/14,Wednesday, 3:00 AM,39,0,0
01/01/14,Wednesday, 3:15 AM,41,0,0
01/01/14,Wednesday, 3:30 AM,39,0,0
01/01/14,Wednesday, 3:45 AM,39,0,0 |
Line 1 = Header
Line 2 = Labels
The rest is information about license usage for our application. How would I format the table to do this?
Any help is MUCH appreciated! _________________ Brent Weaver |
|