Importing and Exporting Data
11 important questions on Importing and Exporting Data
Does LOAD DATA INFILE support multiple tables?
Does SELECT INTO OUTFILE support multiple tables?
What is the format of the LOAD DATA INFILE statement?
[IGNORE | REPLACE]
INTO TABLE table_name
format_specifiers
[IGNORE n LINES]
[(column_list)]
[SET (assignment_list)]
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What does the local option do in the LOAD DATA INFILE statement?
What does the SET clause do in a LOAD DATA INFILE statement?
What is the syntax of the format specifier clause of a SELECT INTO OUTFILE statement?
TERMINATED BY 'string'
ENCLOSED BY 'char'
ESCAPED BY 'char'
LINES TERMINATED BY 'string'
What does OPTIONALLY ENCLOSED BY for a SELECT INTO OUTFILE statement?
What is the meaning of \N, \O and \b in SELECT INTO OUTFILE output?
What is the syntax of the mysql import command?
What is the syntax of the mysqldump command?
What 2 options are mutually exclusive in mysqldump?
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding
![Trustpilot Logo](/images/design_2020/lp/clp-trustpilot-en.png)