'Showing error while uploading data using MySQL command line

I am trying to upload dataset in mysql and it shows syntex error however i have looked in it and there is no syntex error, apart form this i have turned on local_infileuploading as well. enter image description here

'mysql> mysql --local_infile=1 -u root -p world
    -> load data local infile 'C:/path/Desktop/SQL/zomato.csv'
    -> into table zomato
    -> field terminated by ','
    -> enclosed by '"'
    -> lines terminated by '\n'
    -> ignore 1 rows; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql --local_infile=1 -u root -p world load data local infile 'C:/Users/path/' at line 1'
mysqlmysql-workbench


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions