The tab-delimited file”/tmp/people,txt contains:
1636 Carsten Pederson Denmark
4672 Kai Voigt Germany
4628 Max Mether France
This is the structure of the people table:
Mysq1> DESCRIBE people;
Which statement will load the first and last names into the Names column and the country
into the country column?
A.
LOAD DATA INFILE ‘/tmp/people.txt’INTO TABLE PEOPLE@First=$2. @Last=$3
@Country=$4
(CONCAT (@First, ‘ ‘,@Last) , @ Country)
B.
LOAD DATA INFILE ‘/tmp/people.txt ‘ INTO TABLE People
@Skip=$1 , @ First=$2, @Last=$3, @ Country=4,
(CONCAT (@First, ‘ ‘ .@ Last) , @ Country)
C.
LOAD DATA INFILE ‘/tmp/people.txt ‘INTO TABLE People
(@ Skip, @First , @Last, @Country
SET Name=CONCAT (@First, ‘ ‘,@Last)
D.
LOAD DATA INFILE ‘/tmp/people,txt, INTO TABLE People.
(@Skip. @First, @Last, @Country)
Country=@country
E.
It is not possible to load the data from the file/tmp/people.txt into the people table,as
shown.
Correct is C, but is incomplete:
LOAD DATA INFILE ‘/tmp/people.txt’ INTO TABLE People
(@Skip, @First, @Last, @Country)
SET Name=CONCAT(@First,’ ‘,@Last), Country=@Country;
Query OK, 15 rows affected (0,01 sec)
C
C