Can I execute a large number of queries through shell script directly from terminal? 

In MySql I use, mysql -u root -ppassword -e "select * from table"  in my shell script, which returns the result without logging into mysql client. Similarly, I want to execute queries in the terminal without logging into mclient. 

Is there any equivalent way of achieving the same? I have to do a lot of updates and instead of doing those one by one, I prefer writing a shell script to run hundreds of queries one by one automatically. 

Any help much appreciated.