/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 vote192 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote190 views1 answer
Mysql last friday of current month
SQL
0 vote159 views1 answer
Mysql update from select on same table
SQL
0 vote156 views1 answer
MySQL FIND_IN_SET()
SQL
8 votes169 views1 answer
Show mysql user table
SQL
1 vote207 views1 answer
Sql comment header
SQL
18 votes150 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote187 views1 answer
Download mysql database to excel in android studio
SQL
0 vote144 views1 answer
Group by 15 minute interval sql server
SQL
0 vote157 views1 answer
Create or replace view postgress
SQL

Share