I still dont seem to be able to get it. MySQL Import says to type this in
shell> mysqlimport [options] db_name textfile1 [textfile2 ...]
so would I type in
shell> mysqlimport [options] db_name FOOTBALL.TXT;
as this results in "ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqlimport [options] db_name FOOTBALL.TXT' at line 1"
This is my text file named FOOTBALL.TXT
Create database football;
use football;
drop table team;
drop table player;
drop table venue;
drop table match1;
Create table team
(
team_id int not null primary key,
team_name varchar(20),
team_colour varchar(20),
team_coach varchar(20),
team_mngr varchar(20),
team_chrpsn varchar(20)
);
create table player
(
player_id int not null primary key,
player_name varchar(25),
player_posn varchar(2),
player_DOB date,
player_ftdness varchar(1),
player_salary int,
player_team_id int references team(team_id)
);
create table venue
(
venue_id int not null primary key,
venue_name varchar(20),
venue_seats int,
venue_minprice int,
venue_maxprice int,
venue_address varchar(40),
venue_team_id int references team(team_id)
);
create table match1
( match_id int not null primary key,
match_venue_id int references venue(venue_id),
match_home_team_id int references team(team_id),
match_away_team_id int references team(team_id),
match_date date,
match_score_home int,
match_score_away int
);
Insert into team values (111,"Arsenal","Red","Ian Wallace","Arsene Wenger","Frederick Tate");
Insert into team values (222,"Chelsea","Blue","Sam Jefferson","Jose Murinho","John Paul");
Insert into team values (333,"Manchester United","Red","Bill Smithers","Sir Alex Ferguson","Samuel Scum");
insert into team values (444,"Liverpool","Red","Alessandro Pierre","Rafael Benitez","Rick Parry");
Insert into player values (1,"Steven Gerrard","CM",1980-05-20,"R",40000,444);
Insert into player values (2,"Xabi Alonso","CM",1982-08-12,"B",37000,444);
Insert into player values (3,"Fernando Morientes","ST",1981-11-03,"R",27000,444);
Insert into player values (4,"Jamie Carragher","RB",1978-02-28,"B",32000,444);
Insert into player values (5,"Luis Garcia","RW",1984-03-17,"L",22000,444);
Insert into player values (6,"Wayne Rooney","ST",1985-01-11,"R",27000,333);
Insert into player values (7,"Rio Ferdinand","CB",1980-11-28,"R",37000,333);
Insert into player values (8,"Ruud van Nistelrooy","ST",1978-04-23,"R",44000,333);
Insert into player values (9,"Alan Smith","ST",1983-02-08,"R",17000,333);
Insert into player values (10,"Tim Howard","GK",1979-08-30,"R",33000,333);
Insert into player values (11,"Didaer Drogba","ST",1977-01-15,"R",38000,222);
Insert into player values (12,"Joe Cole","LB",1981-09-05,"L",38000,222);
Insert into player values (13,"John Terry","CB",1976-02-26,"R",44000,222);
Insert into player values (14,"Arjen Robben","RW",1978-12-18,"R",49000,222);
Insert into player values (15,"Petr Cech","GK",1981-05-22,"R",37000,222);
Insert into player values (16,"Sol Campbell","CB",1975-09-17,"R",42000,111);
Insert into player values (17,"Jens Lehmann","GK",1977-06-03,"R",22000,111);
Insert into player values (18,"Thierry Henry","ST",1979-10-14,"R",49000,111);
Insert into player values (19,"Dennis Berkamp","RW",1974-08-22,"R",30000,111);
Insert into player values (20,"Patrick Viera","CM",1979-03-19,"B",47000,111);
Insert into venue values (5555,"Ashburton Grove",60000,25,300,"Ashburton Grove London",111);
Insert into venue values (6666,"Stamford Bridge",55000,20,240,"Stamford Bridge London",222);
Insert into venue values (7777,"Old Trafford",50000,20,200,"Theatre of Dreams Manchester",333);
Insert into venue values (8888,"Anfield",44565,15,120,"Ashburton Grove London",444);
Insert into match1 values (1000,5555,111,222,2005-01-01,1,3);
Insert into match1 values (1001,7777,333,444,2005-01-01,1,2);
Insert into match1 values (1002,6666,222,333,2005-01-05,2,0);
Insert into match1 values (1003,8888,444,111,2005-01-05,2,1);
Insert into match1 values (1004,7777,333,111,2005-01-06,3,2);
Insert into match1 values (1005,8888,444,222,2005-01-11,0,2);
Insert into match1 values (1006,5555,111,444,2005-01-11,1,1);
Insert into match1 values (1007,7777,333,222,2005-01-15,1,2);
Insert into match1 values (1008,6666,222,111,2005-01-18,2,2);
Insert into match1 values (1009,8888,444,333,2005-01-25,1,0);
Insert into match1 values (1010,5555,111,333,2005-01-29,0,0);
Insert into match1 values (1011,6666,222,444,2005-02-02,2,2);
, please make some effort to learn the technology.