DML

DML

1. Modificacion de tablas

   • RENAME TO
   • DROP
   • CHANGE
   • ADD
   • MODIFY

2. Funciones

   • INSERT INTO
   • DELETE
   • FROM
   • CHAR
   • CONCAT
   • AVG
   • DISTINCT

3. Consultas

   • SELECT
   • FROM
   • WHERE
   • GROUP BY
   • HAVING
   • ORDER BY
   • LIMIT

4. Subconsultas

   • comparacion (<,>,=,>=...)
   • ALL y ANY
   • Multivalor
   • Having
   • Pertenencia(IN)
   • Existencia (exists, no exists)
   • Anidadas

5. Consultas resumen

   • AVG
   • MIN/MAX
   • SUM
   • COUNT

Bilder und Dateien der Mindmap