Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL - Coggle Diagram
SQL
CREATION /MODIFICATION TABLES
CREATE TABLE
Foreign key
INSERT
UPDATE
DELETE
ALTER TABLE
ADD COLUMN
DROP COLUMN
RENAME TO
DROP TABLE
JOIN
OUTER JOIN
RIGHT JOIN
INNER JOIN
LEFT JOIN = OUTER JOIN
Fonctions
Aggregation
AVG()
COUNT()
MAX()
MIN()
SUM()
Chaines de caractères
LEN(champ) = length(champ)
LOWER(champ)
Change casse en minuscule
UPPER(champ)
change casse en majuscule
SUBSTRING(champ, dp, lg)
LTRIM(champ)/ RTRIM(champ)
RIGHT(champ, n)
LEFT(champ,n)
REPLACE(hamp, vs, vc)
Requêtes
SELECT
DISTINCT
WHERE
Opérateurs
LIKE
IN
NOT IN
BETWEEN
NOT BETWEEN
AS
COUNT ( fonction)
LIMIT
ORDER BY
Fonctions d'aggregation
AVG()
MIN()
MAX()
SUM()
GROUP BY
HAVING
SQL AVANCE
FONCTIONS DATE ET HEURE
EXTRACT()