Execute MySQL statements from a text file

1.First Login to mysql and select your required database
  mysql -uroot -pabcd
  mysql> use mydb;
  mysql> source /tmp/mysqlstatment.sql;