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 vote227 views1 answer
How to update random rows in sql
SQL
1 vote168 views5 answers
What is in operator in sql
SQL
0 vote156 views1 answer
Mysql where in maintain order
SQL
0 vote147 views1 answer
Suse status MySQL
SQL
0 vote158 views1 answer
Sql query wordpress export post
SQL
0 vote162 views1 answer
Query for backup a database at another location in file system
SQL
0 vote141 views1 answer
Close sql query vb.net
SQL
0 vote183 views1 answer
Sql query to select even numbers
SQL
1 vote147 views1 answer
Sql run multiple updates in one query
SQL
65 votes361 views6 answers
Sql add column to table
SQL