Shortcuts to Remember: PostgreSQL, PGAdmin, Oracle SQL, MySQL

Work in progress.

PostgreSQL / PGAdmin

​CREATE TABLE phones (
​name VARCHAR(50),
​manufacturer VARCHAR(50),
​price INTEGER,
​units_sold INTEGER,
​);

Inserting Data into Tables:

INSERT INTO phones