Shell Programming and Scripting

#!/bin/bash

#script that ask for user's name, surname  dob and age

echo "Enter your name"
read name

echo "Enter your surname"
read surname

echo "Enter your dob"
read dob

echo "Enter your age"
read age

age()

{
    age="dob -1901"
}

mysql -hlocalhost -uroot -p 
create database johannesburg;
show databases;
use johannesburg;
show tables;
CREATE TABLE johannesburg1 (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(100), surname VARCHAR(100), dob DATE, age VARCHAR (10),
PRIMARY KEY (id)
);
INSERT into johannesburg1 VALUES ( "$name", "$surname", "$dob", "$age" );

mysql -hlocahost -uroot  -e "
  create table;
  do something else;
  do one more thing;
"

mysql -h localhost -u root -prootpasswd -D johannesburg -e "insert into  johannesburg1 values ('$name','$surname','$dob','$age');"

mysql -h localhost -u root -prootpasswd -D johannesburg < script.sql

mysql -h localhost -u root -prootpasswd -D johannesburg << EOF
create database johannesburg;
CREATE TABLE johannesburg1 (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(100), surname VARCHAR(100), dob DATE, age VARCHAR (10),
PRIMARY KEY (id)
);
INSERT into johannesburg1 VALUES ('$name','$surname','$dob','$age');
quit;
EOF

#!/bin/bash

echo "Enter name"
read name
echo "Enter surname"
read surname
echo "Enter dob"
read dob (i`m not sure if this is the issue cause it keeps on referring to this line)
echo "Enter age"
read age

mysql -hlocalhost -uroot -p -D durban << EOF
#create database durban;
use durban;
#CREATE TABLE soweto (
#id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
#name VARCHAR(100), surname VARCHAR(100), dob DATE, age INTERGER (10),
#PRIMARY KEY (id)
#);
INSERT into soweto VALUES ('$name','$surname','$dob','$age');
quit;
EOF

insert into soweto(name,surname,dob,age) values ('$name','$surname','$dob','$age');

insert into soweto values(' ','$name','$surname','$dob','$age');