UBUNTU>TERMINAL>MYSQL>DATABASE>TABLE

How to Install MySQL
sudo apt-get install mysql-server
How to Access the MySQL shell
mysql -u root -p
How to Create and Delete a MySQL Database
mysql> SHOW DATABASES;
mysql> CREATE DATABASE db_name;
mysql> DROP DATABASE db_name;
mysql> USE db_name;
mysql> SHOW tables;
How to Create a MySQL TableCREATE TABLE tbl_name (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20),
food VARCHAR(30),
confirmed CHAR(1),
signup_date DATE);

mysql> SHOW TABLES;
mysql> DESCRIBE tbl_name;

How to Add Information to a MySQL Table
INSERT INTO `tbl_name` (`id`,`name`,`food`,`confirmed`,`signup_date`) VALUES (NULL, "John", "Casserole","Y", '2012-04-11');
mysql> SELECT * FROM tbl_name;
How to Update Information in the TableUPDATE `tbl_name` SET `confirmed` = 'Y' WHERE `tbl_name`.`name`='Sandy';

How to Add and Delete a ColumnALTER TABLE tbl_name ADD email VARCHAR(40);
ALTER TABLE tbl_name ADD email VARCHAR(40) AFTER name;
ALTER TABLE tbl_name DROP email;

How to Delete a Row
mysql> DELETE from tbl_name where name='Sandy';
mysql> SELECT * FROM tbl_name;