how to run sql script in mysql code example
Example 1: execute mysql file
mysql -u yourusername -p yourpassword yourdatabase < text_file
Example 2: mysql run sql file
mysql> source \home\user\Desktop\test.sql;
mysql -u yourusername -p yourpassword yourdatabase < text_file
mysql> source \home\user\Desktop\test.sql;