MySQL Demo 
----------

$ mysql -h mysql -p my_DB	# Start MySQL
Password		 	# Enter your password

CREATE TABLE test (
name VARCHAR (15),
email VARCHAR (25),
phone_number INT,
ID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (ID));

SHOW TABLES;
SHOW COLUMNS FROM test; 

INSERT INTO test VALUES ('Bugs Bunny', 'carrots@devshed.com', 5554321, NULL);
INSERT INTO test VALUES ('Bugs Bunny', 'peppers@devshed.com', 5554331, NULL);
INSERT INTO test VALUES ('Bugs Bunny', 'lettuce@devshed.com', 5554341, NULL);
INSERT INTO test VALUES ('Bugs Bunny', 'celery@devshed.com', 5554351, NULL);
SELECT * FROM test WHERE (name = "Bugs Bunny");

DELETE FROM test WHERE (phone_number =  5554341);
SELECT * FROM test WHERE (name = "Bugs Bunny");

UPDATE test SET name = 'Daffy Duck' WHERE phone_number = 5554351;
SELECT * FROM test WHERE (name = "Bugs Bunny");

SELECT * FROM test WHERE (name = "Bugs Bunny");

SELECT * FROM test WHERE (name = "Bugs Bunny") AND (phone_number = 5554321);

SELECT * FROM test WHERE (name = "Bugs Bunny") OR (phone_number = 5554321);

SELECT * FROM test WHERE (name != "Bugs Bunny");

SELECT * FROM test WHERE (name = "Bugs Bunny") ORDER BY phone_number;

SELECT * FROM test WHERE (name LIKE "%gs Bunny");

SELECT * FROM test WHERE (name LIKE "Bugs Bunny%");

SELECT name FROM test WHERE (name = "Bugs Bunny");

ALTER table test RENAME mytest;

ALTER table mytest ADD birthday DATE;

ALTER table mytest CHANGE name newname VARCHAR (25);

SHOW TABLES;
SHOW COLUMNS FROM mytest; 

ALTER table mytest DROP newname;

EXIT