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

                    Crime and Deviance with sociological methods key terms
                    emzelise1996
                    GRE Word of the Day
                    SAT Prep Group
                    CHEMISTRY C1 2
                    x_clairey_x
                    A Level: English language and literature techniques = Structure
                    Jessica 'JessieB
                    The Norman Conquest 1066-1087
                    adam.melling
                    English Literature Key Terms
                    charlotteoom
                    Graphing Inequalities
                    Selam H
                    AQA - English Language Unit 1
                    Alice Love
                    CHARACTERS IN OF MICE AND MEN
                    jessicasusanevans
                    Development of Cold War Tensions
                    c7jeremy
                    GCSE Revision Tips
                    miminoma