Examveda

How is a delimited-text data file reloaded?

A. mysqlexport

B. mysqlimport

C. mysqlexpand

D. mysqltransfer

Answer: Option B

Solution (By Examveda Team)

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

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous