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 vote230 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote214 views1 answer
Influxdb clone measurement
SQL
0 vote197 views2 answers
Avg() sql
SQL
0 vote233 views1 answer
Add week ending date sql server
SQL
7 votes208 views2 answers
Sql empty table
SQL
4 votes169 views2 answers
Select todays data postgres query
SQL
-1 vote217 views4 answers
Postgres between dates
SQL
0 vote203 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
7 votes208 views2 answers
Show size database mysql
SQL
0 vote208 views2 answers
Script all indexes in a database
SQL