Import CSV data into MySQL table using query

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);

Тэги:

#MySQL_CSV_import #comma_separated_values_file_data_into_mysql_table #query_to_import_csv_data #mysql_csv_example #mysql_import_data

Скачать видео