Shell Programming and Scripting

#!/bin/bash

mysql -hlocalhost -uroot -p  << EOF

CREATE DATABASE PROJECTS;

SHOW DATABASES;

USE PROJECTS;

CREATE TABLE PROJECT1 (
empNO INTEGER UNSIGNED, projectID INTEGER UNSIGNED, projectName VARCHAR(100), budget INTEGER UNSIGNED,
PRIMARY KEY (empNO));
INSERT INTO PROJECT1 (empNO, projectID, projectName, budget) VALUES ("15", "1", "Interface Design", "10000");
SELECT * FROM PROJECT1;

empNO                               projectID                                          projectName                                                budget
   15                                                    1                                                            interface design                                   10000
   17                                        2                                           e-commerce solution                 20000
   19                                        3                                           advertising                                 30000
   21                                        4                                           administrators                           40000