/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 vote180 views1 answer
How to set all the min and sec data to zero in sql server
SQL
3 votes181 views1 answer
Sql is not like
SQL
0 vote185 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote187 views1 answer
Mysql take number in string
SQL
23 votes183 views4 answers
Sql server substring
SQL
0 vote187 views2 answers
How to find max and min salary in sql
SQL
0 vote167 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote170 views2 answers
Clear window pl sql
SQL
0 vote207 views1 answer
Sql value exists in column
SQL
14 votes264 views1 answer
How to export db from mysql
SQL

Share