Is there a way I can access MySQL database using shell script?
want to do some selects and some inserts on multiple tables?
It will be great if you can give some sample code as I am new to scripting.
This link seems to have the information you want.
mysql -u user -p dbnane