Vidyalelo
MySQL · Q775

MySQL

Programming · MySQL · question 775

Q775

How is a delimited-text data file reloaded?

A.
mysqlexport
B.
mysqlimport
Answer
C.
mysqlexpand
D.
mysqltransfer

Answer: Option B

Solution

Answer: Option B
Solution:
This question asks about how to load data from a file that has data separated by a specific character (like a comma or tab). Think of it like a spreadsheet saved as a text file.

The command used for this is mysqlimport.

Let's break down why the other options aren't correct:

* mysqlexport: This command is used to export data from a MySQL database to a file. It's the opposite of what we want to do.
* mysqlexpand: This command doesn't exist in MySQL.
* mysqltransfer: This command isn't a standard part of MySQL.

Therefore, the correct answer is Option B: mysqlimport