SELECT *( , ) FROM Table WHERE criteres; ( = > < <> != >= <=)
RechercheSELECT champ1, champ2 FROM table WHERE champ1 LIKE '%bla%'; ( % signifie un nombre indéterminé - _ signifie un caractere quelconque (1 et 1 seul))
SELECT champ FROM table WHERE champ='' OR champ =''; (OR AND NOT)
SELECT champ FROM table WHERE NOT (champ='' OR champ='');
IntervalSELECT champ FROM table WHERE champ BETWEEN 'valeur1' AND 'valeur2';
Choix multipleSELECT champ FROM table WHERE champ IN ('val1','val2','val3');
Champ #NULLSELECT champ FROM tabla WHERE champ IS NULL; ( NULL n'est rien -> !=0, !='')
ALIASSELECT longchamp AS lc FROM longtable lt;
CASESELECT champ, (CASE WHEN champ2='val' THEN 'val+1' ELSE 'val' END) FROM table;
Opérations sur champsSELECT CONCAT (cp, ville) AS "cp - ville" FROM ville SUBSTRING (ville,1,4)='nant'; (CONCAT concaténation - SUBSTRING sous chaine qui commence a la position 1 et de longueur 2)
Type donnéeSELECT CAST (cp as integer) FROM table; (change le type de donnée)
ORDER BYSELECT champ FROM table ORDER BY champ DESC/ASC;
GROUP BYSELECT champ FROM table GROUP BY champ;
SELECT champ FROM table GROUP BY champ HAVING count(table)>2;
JointureSELECT champ FROM table,table2 WHEREt.champ = t2.champ;
INNER JOINSELECT champ FROM table INNER JOIN table2 ON t.champ=t2.champ;
LEFT JOINSELECT champ FROM table LEFT JOIN table2 ON t.champ=t2.champ; (tous les champs de la table de gauche, même s'il n'y pas de correspondance dans la table 2)
RIGHT JOINSELECT champ FROM table RIGHT JOIN table2 ON t.champ=t2.champ; (tous les champs de la table de droite, même s'il n'y pas de correspondance dans la table 1)
INSERTIONINSERT INTO table (champ1,champ2,...) VALUES (val1,val2,...);
UPDATEUPDATE table SET champ=val WHERE champ2=val2;
DELETEDELETE FROM table WHERE champ=val;
DROPDROP TABLE table;