Question

QUESTION 8 1create table plantz (name VARCHAR (30)) 2 3 SQHcse /Desktop/plants.csv Output Action Output Message Time Action 1 16:01:06 create table plantz (name VARCHAR(30) source. Emor Code: 1064. You have an error in your SQL s... 0. The screenshot above shows an error that has been produced when running a query in MySQL to import data from a csv file into the table created. Which of the following is the most likely reason this error occurred? O There are not enough attributes in the table plantz to import the data into The SOURCE command was the incorrect command to use to import the data and instead the LOAD DATA LOCAL INFILE command should have been used O The file path in the query is wrong The semicolon for the source command was on the line after the command was written

Answer 1

The reason for this error is the SOURCE command was the incorrect command to use to import the data and instead the LOAD DATA LOCAL INFILE command should have been used