Lenguaje de Manipulación de Datos (LMD)

Description

Mind Map on Lenguaje de Manipulación de Datos (LMD), created by Nancy Aide on 26/02/2017.
Nancy Aide
Mind Map by Nancy Aide, updated more than 1 year ago
Nancy Aide
Created by Nancy Aide over 7 years ago
32
0

Resource summary

Lenguaje de Manipulación de Datos (LMD)
  1. SELECT
    1. Sintaxis: SELECT campos FROM tabla
      1. Cláusulas: FROM, WHERE, GROUP BY, HAVING, ORDER BY.
        1. predicado: ALL, TOP, DISTINCT, DISTINCTROW
        2. INSERT
          1. Sintaxis: INSERT INTO "tabla"(columna1, columna2)VALUES(valor1, valor2..)
            1. cantidad columnas = cantidad valor
            2. UPDATE
              1. Sintaxis
                1. Modifica valores de un conjunto de registros.
                2. DELETE
                  1. Borra 1 o mas registros de la tabla
                    1. Sintaxis
                    Show full summary Hide full summary

                    Similar

                    German- Beginner
                    PatrickNoonan
                    SAT Exam 'Word of the Day' Set 2
                    SAT Prep Group
                    History of Medicine: Ancient Ideas
                    James McConnell
                    MCAT Study Plan
                    Alice McClean
                    GCSE Biology AQA
                    isabellabeaumont
                    Practice For First Certificate Grammar I
                    Alice McClean
                    B3, C3, P3
                    George Moores
                    GCSE Maths: Statistics & Probability
                    Andrea Leyden
                    An Inspector Calls- Quotes
                    ae14bh12
                    3.1 Keywords - Marketing
                    Mr_Lambert_Hungerhil
                    1PR101 2.test - Část 1.
                    Nikola Truong