Computer scienceFundamentalsSQL and DatabasesDBMSMySQLMySQL syntax

Import and export CSV files

What is the problem?

Report a typo

This query is not working, why?

LOAD DATA LOCAL INFILE  'D:/data/test.csv'
INTO TABLE andrey_test.test_data

Select one option from the list

Lines contains /n.

Data in file is separated with tabs/semicolons, etc. and not with commas.

First row of the file contains the name of the columns.

All options are correct.

___

Create a free account to access the full topic