Shell Programming and Scripting

No help guys???

Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file...

so the first move would be, to access the mysql interface right? hence...

#! /usr/bin/ksh

echo "Job Begin: " `date`

cd /usr/local/mysql/bin

./mysql -u root -pxxxxxx

everything is okay... but after that....
when i type a mysql command in the script for example..

use special;

show tables;

it seems that the script is not able to execute these lines into the mysql...

any idea's or walk around for this problem..?

many thanks in advance...!

Guys .... i found the way...
you can.. use the line below to execute a line after your inside the mysql window.

#/usr/local/mysql/bin/mysql --user=xxx --password=xxx [db name] -e 'select * from whatever'

Anyways, thanks for those who at least saw this thread and was trying to help..
thanks a bunch