How to load files in mysql

Mysql load sql from file

 mysql> use db_name;
 mysql> source file_name.sql;

Source: stackoverflow.com

How to load files in mysql

LOAD DATA INFILE 'c:/tmp/discounts.csv' 
INTO TABLE discounts 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
Code language: SQL (Structured Query Language) (sql)

Source: mysqltutorial.org

Similar codes

1 vote224 views1 answer
Mysql view current queries
SQL
2 votes203 views2 answers
Laravel query builder toSql
SQL
-1 vote208 views1 answer
How to open blade file from blade in laravel
SQL
-2 votes206 views2 answers
Add auto_increment column to existing table mysql
SQL
17 votes219 views3 answers
Postgresql list users
SQL
1 vote212 views1 answer
Mysql find tables with column name
SQL
0 vote215 views1 answer
Top 3 salary in sql
SQL
2 votes223 views1 answer
Column names in oracle sql
SQL
0 vote192 views2 answers
Sqlite unique
SQL
9 votes219 views4 answers
Last mysql
SQL