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

2 votes135 views2 answers
Mysql all columns
SQL
0 vote144 views2 answers
Mysql multiply
SQL
0 vote168 views1 answer
Flask sqlalchemy session delete
SQL
0 vote150 views1 answer
How to run mysql on terminal mac
SQL
0 vote144 views1 answer
Which lock mode is not available in sql
SQL
0 vote160 views1 answer
Pgadmin check database
SQL
-2 votes148 views2 answers
Union vs union all in sql
SQL
0 vote142 views1 answer
Basic structure of sql expression having clause
SQL
0 vote151 views1 answer
How to get nth number in sql
SQL
0 vote144 views1 answer
Sql select rows with different values in one column
SQL