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

7 votes114 views1 answer
Mysql iif
SQL
0 vote117 views1 answer
Postgress append string in select
SQL
1 vote111 views1 answer
Mysql Case sum
SQL
4 votes128 views4 answers
Mysql get date from datetime
SQL
0 vote132 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote118 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote108 views1 answer
Pl/sql loop example
SQL
7 votes116 views1 answer
Buy forge mods server hosting
SQL
0 vote128 views1 answer
Mysql insert into select transaction c#
SQL
0 vote107 views1 answer
How to fetch unique records from two tables
SQL