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

8 votes370 views2 answers
Alert table name mysql
SQL
4 votes399 views6 answers
List all tables in postgres
SQL
0 vote380 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
2 votes338 views5 answers
Alter table primary key postgresql
SQL
0 vote346 views1 answer
Check duplicate values plsql
SQL
1 vote351 views1 answer
Show all event schedular on mysql
SQL
0 vote370 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
17 votes382 views4 answers
Show tables sql server
SQL
2 votes355 views1 answer
Drop all database tables oracle sql developer
SQL
5 votes342 views1 answer
How to check port number for postgresql
SQL