...@googlemail.com]
Sent: Tuesday, April 06, 2010 11:42 AM
To: [MySQL]
Subject: Restricting data input
Hi
I have a table that contains league standings type information for a soccer
league. For example
season_id
round_id
team_id
league_id
home_won
home_draw
home_lost
home_goals
home_conceded
round results for each team. From
here I can display the league standings for each round for each league. My
question is how / what is the best way to restrict incorrect data input
apart from a coding issue/bug - e.g I need to ensure that for each round a
team can only have either a value in the f
> The Database is called wald_data and the fields are:-
> f_name varchar(30) not null,
> t_name varchar(120) not null,
> sub_p varchar(120) not null,
> sub_g varchar(120) not null,
> datevarchar(30) not null
At 20:35 -0700 7/2/02, Martin Scherer wrote:
>I am trying to import a text file that is tab delimited.
>
>I am using the following , but it only returns one line.
>
>LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO
>TABLE Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
I am trying to import a text file that is tab delimited.
I am using the following , but it only returns one line.
LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO TABLE
Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
Why would it do one line and then stop? MySQL i