To import a text file into MySQL, the text file must be ____ and the data should not be enclosed in quotation marks.
A)tab-delimited
B)comma-delimited
C)slash-delimited
D)hyphen-delimited

Question

Quizplus · Accepted Answer

MySQL uses the LOAD DATA INFILE statement to import data from a text file into a database table. By default, it assumes that the data is tab-delimited, meaning that each field in the text file is separated by a tab character. If the data is not tab-delimited, you can specify the delimiter using the FIELDS TERMINATED BY option in the LOAD DATA INFILE statement. The data should not be enclosed in quotation marks, as this can cause issues with the import process.

To Import a Text File into MySQL, the Text File