/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 vote122 views1 answer
SQL date part only of datetime
SQL
1 vote124 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote123 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote121 views1 answer
Heavy table in mysql
SQL
0 vote111 views1 answer
Minecraft duping allowed servers
SQL
2 votes175 views2 answers
Mysql date range
SQL
11 votes197 views2 answers
Sql between date range
SQL
0 vote126 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote132 views1 answer
Ansi sql count duplicate rows
SQL
0 vote140 views1 answer
How to read the potentail error messages in ssis package
SQL

Share