SQL Quick Reference Part 1

Keyword : SQL Quick Reference Part 1, create, database, delete, drop, insert, SQL

Berikut merupakan table contoh sintax SQL...

SQL Statement		Syntax
AND / OR		SELECT column_name(s) FROM table_name WHERE condition AND|OR condition
AS (alias)		SELECT column_name AS column_alias FROM table_name or SELECT column_name FROM table_name AS table_alias
BETWEEN		SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2
CREATE DATABASE		CREATE DATABASE database_name
CREATE TABLE		CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name2 data_type, ... )
CREATE INDEX		CREATE INDEX index_name ON table_name (column_name) or CREATE UNIQUE INDEX index_name ON table_name (column_name)
CREATE VIEW		CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition