Principales consultas sql

Flashcards by Gutierrez Mendoza Jhonatan Henry, created 3 months ago

Ayudas memorias para recordar la funcion de las principales consultas sql

	Created by Gutierrez Mendoza Jhonatan Henry 3 months ago

/ 6

Please wait - loading…

SELECT columna1, columna2 FROM tabla WHERE condicion;

INSERT INTO tabla (columna1, columna2) VALUES (valor1, valor2);

UPDATE tabla SET columna1 = valor1, columna2 = valor2 WHERE condicion;

DELETE FROM tabla WHERE condicion;

SELECT columna1, columna2 FROM tabla1 JOIN tabla2 ON tabla1.columna_id = tabla2.columna_id;

SELECT SUM(columna1) FROM tabla;