My Database note MySQL SQLite

Fast Note:

mysql -u root -p

show database;

create database  XXXX;   (Create a database)   Note: Database name is case-sensitive!!

use XXXX;  (Choose a database for seeing its tables)  ==> show tables;

drop XXXX;   (Delete a database)

CREATE TABLE potluck (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20),
food VARCHAR(30),
confirmed CHAR(1),
signup_date DATE);

show tables;

describe Table_Name;    (show the details of the table)


Good Tutorial:
https://www.digitalocean.com/community/tutorials/a-basic-mysql-tutorial


PostgreSQL installation
https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-14-04