| 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 |
Online Web Tutoriel France 