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

58 votes546 views4 answers
Mysql drop column
SQL
0 vote300 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote308 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote330 views1 answer
Search mysql database for column
SQL
0 vote309 views1 answer
Number(10 2) in sql means
SQL
0 vote298 views1 answer
Oracle create package body
SQL
1 vote313 views1 answer
Mysql month name extract
SQL
8 votes310 views4 answers
Mysql update one table from another table multiple columns
SQL
25 votes343 views6 answers
Import database mysql command line
SQL
0 vote318 views2 answers
Select index table oracle
SQL