Code:
#!/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;
the output should show a diagram with relevert info:
Code:
empNO projectID projectName budget
15 1 interface design 10000
17 2 e-commerce solution 20000
19 3 advertising 30000
21 4 administrators 40000