sql_snippets

SQL - my collection
===================

## CREATE TABLE

CREATE TABLE my_table
	(
		first_name VARCHAR(50),
		last_name VARCHAR(50),
		email VARCHAR(50),
		birthday DATE,
		gender CHAR.
		number INT,
		decimalNumber DECIMAL(4,2)
	);


## INSERT

INSERT INTO tabel (kolonn1, kolonne2) VALUES (nr1, nr2);


## SELECT

SELECT * FROM table;
SELECT 'first_name','last_name' FROM TABLE table;