CODEWITHSUNDEEP
mysqlcsv
sofrustrated
sofrustrated

Reputation: 1311

Syntax Error - Trying to import csv file into mysql shell

Full disclosure: I'm a complete beginner to MySQL.

I've spent over 8 hours looking at mysql documentation, stackoverflow responses, and youtube trying to figure out how to import a simple .csv file into mysql shell for the purposes of practicing SQL queries. I know there is an import button that I can use in the MySQL workbench, but this took my 2015 12-inch mac roughly 1 HR to upload a 33.65 mb file. I've read on stackoverflow that a command line prompt in the mysql shell will be considerably faster.

The .csv file in question is in this link: https://www.kaggle.com/PromptCloudHQ/toy-products-on-amazon

I've input the following queries in my mySQL shell:

create database amazon;

use amazon;

CREATE TABLE toys (
uniq_id VARCHAR(1000),
product_name VARCHAR(1000),
manufacturer VARCHAR(1000),
price VARCHAR(1000),
number_available_in_stock VARCHAR (1000),
number_of_reviews INT,
number_of_answered_questions INT,
average_review_rating VARCHAR(1000),
amazon_category_and_sub_category VARCHAR(1000),
customers_who_bought_this_item_also_bought VARCHAR(1000),
description VARCHAR(1000),
product_information VARCHAR(1000),
product_description VARCHAR(1000),
items_customers_buy_after_viewing_this_item VARCHAR(1000),
customer_questions_and_answers VARCHAR(1000),
customer_reviews VARCHAR(1000),
sellers VARCHAR(1000)
);

LOAD DATA LOCAL INFILE ‘/Users/Dave/Desktop/amazonsample.csv’ INTO TABLE toys
FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘\n’
IGNORE 1 LINES
(uniq_id, product_name, manufacturer, price, number_available_in_stock, number_of_reviews, number_of_answered_questions, average_review_rating, amazon_category_and_sub_category, customers_who_bought_this_item_also_bought, description, product_information, product_description, items_customers_buy_after_viewing_this_item, customer_questions_and_answers, customer_reviews, sellers)
;

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 '‘/Users/Dave/Desktop/amazonsample.csv’ INTO TABLE toys FIELDS TERMINAT' at line 1

I sincerely ask that you use simple language if you choose to respond! Thank you so much

Upvotes: 2

Views: 953

Answers (1)

nbk
nbk

Reputation: 49410

Your apostrophes are all wrong use only single

Like

LOAD DATA LOCAL INFILE '/Users/Dave/Desktop/amazonsample.csv' INTO TABLE toys
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(uniq_id, product_name, manufacturer, price, number_available_in_stock, number_of_reviews, number_of_answered_questions, average_review_rating, amazon_category_and_sub_category, customers_who_bought_this_item_also_bought, description, product_information, product_description, items_customers_buy_after_viewing_this_item, customer_questions_and_answers, customer_reviews, sellers)
;

Upvotes: 1

Related Questions