?
How is a delimited-text data file reloaded?
Answer & Solution
Correct Answer:
Option
B
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
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
Join the Discussion
Login to post a comment or share your explanation.
Login