/SQL/Mysql run sql file

Mysql run sql file

Execute mysql file

mysql -u yourusername -p yourpassword yourdatabase < text_file

4

Mysql load sql from file

 mysql> use db_name;
 mysql> source file_name.sql;

3

Source: stackoverflow.com

Mysql run sql file

mysql> source \home\user\Desktop\test.sql;

2

Similar codes

0 vote375 views1 answer
Least spark sql
SQL
4 votes362 views2 answers
Dbms output
SQL
0 vote350 views1 answer
Sql find all different values in column
SQL
7 votes367 views1 answer
Sql disable safe mode
SQL
-1 vote329 views2 answers
On delete set default sql server
SQL
0 vote345 views1 answer
Sql recherche nom prenom
SQL
0 vote362 views1 answer
Oracle service name view
SQL
0 vote374 views1 answer
How to find the most occuring in SQL
SQL
0 vote363 views1 answer
SQL Where-Klausel
SQL
15 votes363 views7 answers
MYSQL
SQL

Share