Shell Programming and Scripting

I am newbie in Unix and Expect script, so please help me
I'm using expect script for remote another host:

Code:

#!/usr/bin/expect -f

set timeout 10
spawn ssh -l root 10.120.18.4
expect "password:"
send "password\r"
expect "@"
interact

And now how can i use expect script for access mysql on 18.4 and insert data?
I used script below:

Code:

set timeout 10
spawn ssh -l root 10.120.18.4
expect "password:"
send "password\r"
expect "@"
interact
spawn mysql -uroot -pPassword DatabaseName
expect "mysql>"
return

However the result is only access host 18.4 and doesn't show mysql.

Please help me!

Yes i will apply this rule, as your experience in Unix can you provide me the way: using expect script for insert/update database in another host like my background:

Host A contain the web APP for register user, the user information contained by database name USER on host B

Now i am at host A and want using expect script for create user on web App and after that insert/update user on database USER on host B!
I can create the user on web App on host A with expect script but i don't know the way for using expect script: insert and update user on database USER on host B!

Thanks!