Importing a .txt flat file database

W

wxdqz

New Member
There may be a easy way to do this, but I have not found it. If anyone can help, please do.

How would I get a comma deliminator database imported into my mysql database?


Here is an example of my comma database file:


"GAME","Type","FGA","FGM","Pts","Ast","Tot Reb","Blk Sh","Turn","Recoveries"
"1 Germantown","Season","18","6","14","1","15","0","5","2"
"2 Grafton","Season","10","3","8","3","13","4","0","6"


Here is my table layout:


CREATE TABLE Stats (
playerid varchar(30) NOT NULL,
gameid varchar(30) NOT NULL,
statentryid int(30) NOT NULL auto_increment,
bbshotattempts int(30) NOT NULL,
bbshotsmade int(30) NOT NULL,
bbpoints int(30) NOT NULL,
bbrebounds int(30) NOT NULL,
bbsteals int(30) NOT NULL,
bbturnovers int(30) NOT NULL,
bbblockedshots int(30) NOT NULL,
bbassists int(30) NOT NULL,
bbadditional text NOT NULL, UNIQUE
statentryid (statentryid) );


Can I use a function in phpmyadmin? Please help a.s.a.p. if possible. Thanks ahead of time.


Jason
 
You must log in or register to reply here.
Back
Top