writting shell script for creating database

[Pankaj Kapare]

Hi,   I am sorry for  putting my question on this platform.But i got stuck up at one thing.Can anybody help me?   I want to write the shell script to create database and running one script file (.sql) in the same shell script which will create some tables.under newly created database. But I dont know how to do that.I am using MySql db. Thanks in advance! Regards, pankaj