SQL référence rapide De W3Schools

référence rapide De W3Schools

Instruction SQL	Syntaxe
ET / OU	SELECT column_name (s) FROM table_name WHERE ET | OU condition
ALTER TABLE	ALTER TABLE nom_table ADD nom_colonne type_donnéesou ALTER TABLE nom_table DROP COLUMN nom_colonne
AS (alias)	SELECT column_name AS alias_colonne FROM nom_de_tableou SELECT nom_colonne FROM table_name AS table_alias
ENTRE	SELECT column_name (s) FROM table_name WHERE column_name ENTRE valeur1 et valeur2
CREATE DATABASE	CREATE DATABASE database_name
CREATE TABLE	CREATE TABLE nom_table ( colonne 1 data_type, column_name2 data_type, column_name2 data_type, ... )
CREATE INDEX	CREATE INDEX nom_index ON nom_table (nom_colonne)ou CREATE UNIQUE INDEX nom_index ON nom_table (nom_colonne)
CREATE VIEW	CREATE VIEW view_name AS SELECT column_name (s) FROM table_name WHERE condition
SUPPRIMER	DELETE FROM table_name WHERE some_column = some_valueou DELETE FROM table_name ( Remarque: Supprime la table entière!) DELETE * FROM table_name ( Remarque: Supprime la table entière!)
DROP DATABASE	DROP DATABASE database_name
DROP INDEX	DROP INDEX table_name.index_name (SQL Server) DROP INDEX nom_index ON nom_table (MS Access) DROP INDEX nom_index (DB2/Oracle) ALTER TABLE nom_table DROP INDEX nom_index (MySQL)
DROP TABLE	DROP TABLE nom_table
GROUP BY	SELECT nom_colonne, aggregate_function (nom_colonne) FROM table_name WHERE valeur column_name opérateur GROUP BY nom_colonne
AYANT	SELECT nom_colonne, aggregate_function (nom_colonne) FROM table_name WHERE valeur column_name opérateur GROUP BY nom_colonne aggregate_function opérateur de valeur HAVING (nom_colonne)
EN	SELECT column_name (s) FROM table_name WHERE column_name IN (valeur1, valeur2, ..)
INSERT INTO	INSERT INTO nom_table VALUES (valeur1, valeur2, valeur3, ....)ou INSERT INTO nom_table (colonne1, colonne 2, colonne 3, ...) VALUES (valeur1, valeur2, valeur3, ....)
INNER JOIN	SELECT column_name (s) DE table_name1 INNER JOIN table_name2 SUR table_name1.column_name = table_name2.column_name
LEFT JOIN	SELECT column_name (s) DE table_name1 LEFT JOIN table_name2 SUR table_name1.column_name = table_name2.column_name
RIGHT JOIN	SELECT column_name (s) DE table_name1 RIGHT JOIN table_name2 SUR table_name1.column_name = table_name2.column_name
FULL JOIN	SELECT column_name (s) table_name1 DE FULL JOIN table_name2 SUR table_name1.column_name table_name2.column_name =
COMME	SELECT column_name (s) FROM table_name WHERE column_name modèle LIKE
ORDER BY	SELECT column_name (s) FROM table_name ORDER BY nom_colonne [ASC | DESC]
SELECT	SELECT column_name (s) FROM table_name
SELECT *	SELECT * FROM table_name
SELECT DISTINCT	SELECT DISTINCT column_name (s) FROM table_name
SELECT INTO	SELECT * INTO new_table_name [EN externaldatabase] DE old_table_nameou SELECT column_name (s) EN new_table_name [EN externaldatabase] DE old_table_name
SELECT TOP	SELECT nombre TOP | column_name pour cent (s) FROM table_name
TRUNCATE TABLE	TRUNCATE TABLE nom_table
UNION	SELECT column_name (s) table_name1 DE L'UNION SELECT column_name (s) DE table_name2
UNION ALL	SELECT column_name (s) DE table_name1 UNION ALL SELECT column_name (s) DE table_name2
MISE À JOUR	MISE À JOUR nom_table SET column1 = valeur, column2 = valeur, ... OÙ some_column = some_value
OÙ	SELECT column_name (s) FROM table_name WHERE opérateur valeur column_name

Source: http://www.w3schools.com/sql/sql_quickref.asp