LOAD DATA FROM CSV FILE IN MYSQL

PHOTO EMBED

Sat Apr 01 2023 08:57:51 GMT+0000 (Coordinated Universal Time)

Saved by @irfan309 #sql #mysql

load data infile '/home/cloudera/Desktop/shared_local/flipkart_dataset.csv'
into table flipkart_tab
fields terminated by ','
enclosed by '"' LINES
TERMINATED BY '\n' (category_1,category_2,category_3,title,product_rating,selling_price,mrp,seller_name,seller_rating,description,highlights,image_links);
content_copyCOPY

THIS IS THE CMD TO LOAD THE DATA FROM CSV FILE INTO THE TABLE IN MYSQL