mysql script in a command shell

Shell Programming and Scripting
1

Hi

i`m trying this script to run and i get the following error.
Enter your name
tman
Enter your surname
smith
-bash: ./500: line 20: unexpected EOF while looking for matching `"'
-bash: ./500: line 21: syntax error: unexpected end of file

--------------------------------------------------------------------------

#!/bin/bash

echo "Enter your name"
read name
echo "Enter your surname"
read surnameINSERT into data 
echo "Enter your dob
read dob
mysql -uroot -p -hlocalhost
Age ()
{
        Age=dob -2011
}
create database info;
CREATE TABLE data (id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(1000),
Age INTERGER,
PRIMARY KEY (id)
);
INSERT into data ( name, surname, Age ) VALUES ("$name", "$surname", "$Age");
2

read surnameINSERT into data

echo "Enter your dob"

3

thanks to that but now when i check on mysql i cant find the database

---------- Post updated at 11:05 AM ---------- Previous update was at 08:39 AM ----------

when i put the sign # in the beginning of the each line in the script and leave out this line (create table info;) copy the logon details (mysql -hlocalhost -uroot -p <the path of my .sh script) and run it on another shell. with only that line i`m able to create the database.