Which of the following are some general properties of the mysqlimport client program?

The correct answer is A. It loads data files into tables. C. It provides a command-line interface to the LOAD DATA INFILE. D. It can load files both on the client and server host. The mysqlimport client program loads data files into tables. It provides a command-line interface to the LOAD DATA INFILE statement. That is, mysqlimport examines the options given on the command line. It then connects to the server and, for each input file named in the…

Using MySQL Client Programs

Question

Options

AIt loads data files into tables.
BIt can load files only on the server host.
CIt provides a command-line interface to the LOAD DATA INFILE.
DIt can load files both on the client and server host.
EIt bypasses the server and writes directly to the corresponding data files.

How the community answered

(47 responses)

A
83% (39)
B
11% (5)
E
6% (3)

Explanation

The mysqlimport client program loads data files into tables. It provides a command-line interface to the LOAD DATA INFILE statement. That is, mysqlimport examines the options given on the command line. It then connects to the server and, for each input file named in the command, issues a LOAD DATA INFILE statement that loads the file into the appropriate table.

Topics

#mysqlimport#LOAD DATA INFILE#data import#client vs server host

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice