/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

-1 vote304 views1 answer
Get month and year from date in mysql sequelize
SQL
1 vote194 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote189 views1 answer
Select place default lat long
SQL
3 votes207 views1 answer
Force using index oracle
SQL
0 vote248 views1 answer
How many rows affected in sqllite
SQL
1 vote196 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote336 views1 answer
Oracle sql alter view add column
SQL
9 votes173 views3 answers
Show table columns mysql command line
SQL
34 votes227 views6 answers
Sql change data type
SQL
16 votes222 views1 answer
Mysql smallint range
SQL

Share