Import CSV data into MySQL table using query

Published: 18 August 2017
on channel: Gautam Mokal

41,694

214

This video demonstrates how we can write a query in mysql to import CSV data into a database table. Following query is used in the example shown in this video.

load data infile 'D:/sql/data/mysqldata/employees.csv' into table employees fields terminated by ',' lines terminated by '\n' (name,city,salary);

Watch video Import CSV data into MySQL table using query online without registration, duration hours minute second in high quality. This video was added by user Gautam Mokal 18 August 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 41,694 once and liked it 214 people.