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 vote365 views2 answers
Dbms interview questions
SQL
0 vote385 views1 answer
Show all sequences postgres
SQL
8 votes376 views1 answer
Script to add datafile to tablespace
SQL
1 vote392 views2 answers
Remove space in mysql
SQL
2 votes344 views1 answer
Oracle cpu per session
SQL
0 vote361 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote364 views1 answer
Linebreak sql
SQL
0 vote356 views1 answer
Monthly Birthday SQL Query
SQL
0 vote369 views1 answer
Automated psql csv export script on windows
SQL
1 vote364 views2 answers
Regex starts with
SQL