Flashcards
Ficha
Cards in this deck (2)
- 1Sentencia INSERTINSERT:
Agrega filas en una tabla.
Unica sentencia que provee SQL para agregar filas.
Existen 2 Formas de ejecutar el insert
1) Usando la cláusula VALUES (agrega una sola fila por cada comando insert)
INSERT INTO table [(column [, column...])]
VALUES (value [, value...]);
INSERT INTO empleados VALUES (1, ‘Juan Perez’, ‘04/04/98’, 100)
INSERT INTO deptos (dcod, ddescr) VALUES (50, ‘CONTABILIDAD')
INSERT INTO deptos VALUES (50, ‘CONTABILIDAD') - 2Sentencia SELECTSELECT [ALL/DISTINCT] select_list
FROM table [table alias] [,...]
[WHERE condition]
[GROUP BY column_list]
[HAVING condition]
[ORDER BY column_name [ASC/DESC] [,...]
Information
- Description
- User has deleted their subject information Flashcards on Ficha, created by Deleted user on 22/10/2017.
- Created by
- Deleted user · Oct 2017
- Updated
- Oct 22, 2017
- Views
- 23
- Tags
- History
-
- Created by Carlos Navarro · Oct 22, 2017
- Copied by Carlos Navarro · Oct 22, 2017
- Rating