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

0 vote154 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote159 views1 answer
Drop index in sql
SQL
0 vote183 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote142 views1 answer
Psql connections
SQL
0 vote141 views1 answer
Sql server order by nulls last
SQL
2 votes135 views4 answers
Duplicate record mysql
SQL
0 vote145 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote129 views1 answer
How to create an SQL save method in ruby
SQL
0 vote144 views1 answer
Mysql a from on this page has
SQL
11 votes214 views5 answers
Update table from another table mysql
SQL