mysql command line execute script code example
Example 1: execute mysql file
mysql -u yourusername -p yourpassword yourdatabase < text_file
Example 2: mysql execute command from command line
mysql -u <user> -p -e "select * from schema.table"
mysql -u yourusername -p yourpassword yourdatabase < text_file
mysql -u <user> -p -e "select * from schema.table"