Which statement will load the first and last names into the Names column and the country into the country column?

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?

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


gelito

gelito

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)