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 vote184 views1 answer
How to add boolean column in postgresql
SQL
0 vote272 views1 answer
Install ms sql server management studio
SQL
1 vote213 views1 answer
T-SQL Alter the column data type
SQL
-1 vote238 views1 answer
Difference berween database and data base management system
SQL
5 votes236 views3 answers
Sql server utc to local
SQL
3 votes193 views2 answers
Sql select data from last week
SQL
3 votes184 views3 answers
Your password does not satisfy the current policy requirements
SQL
3 votes195 views2 answers
Postgres alter table owner
SQL
0 vote246 views1 answer
Generate random & unique mysql string
SQL
0 vote185 views1 answer
SAP Return
SQL