Playground: INSERT, UPDATE y DELETE en SQL

Clase 18 de 34 • Curso de Bases de Datos con MySQL y MariaDB

Clase anteriorSiguiente clase

Marco Fernando Aguirre Noboa

student•

Me encanta que hayan incluido los playgrounds. Son sumamente dinamicos y te insita a practicar lo estudiado,

Brandon Gutierrez

student•

Mi solucion.

INSERT INTO lines (id, name, color)
VALUES (7, 'Nueva Linea 7', 'Naranja');

UPDATE lines
SET name = 'Linea 1'
WHERE id = 1;

DELETE FROM lines
WHERE id = 5;

SELECT * FROM lines;

Edgar Yair Ariza Gonzalez

student•

Adan Cancino Mendoza

student•

Easy

Ronald Martin Saavedra Garay

student•

SELECT * FROM lines;
INSERT INTO lines (id,name,color)VaLUES(7,"Nueva Linea 7", "Naranja");
UPDATE lines SET name="Linea 1" WHERE id=1;
DELETE FROM lines WHERE id=5;
```SELECT \* FROM lines;
INSERT INTO lines (id,name,color)VaLUES(7,"Nueva Linea 7", "Naranja");
UPDATE lines SET name="Linea 1" WHERE id=1;
DELETE FROM lines WHERE id=5;

Andrés Gabriel Torrez Mamani

student•

Completado:

Rodwel Polanco Martinez

student•

INSERT INTO lines (id, name, color) VALUES (7, "Nueva Linea 7", "Naranja"); SELECT * FROM lines; UPDATE lines SET name="Linea 1" WHERE id=1; SELECT * FROM lines; DELETE FROM lines WHERE id=5; SELECT * FROM lines;

Jovar Sorel Gil Zapata

student•

Aquí mi solución

Oscar Alirio Vargas Ayala

student•

-- Escribe tu código aquí 👇
SELECT * FROM lines;
INSERT INTO lines (id,name,color) VALUES ("7","Nueva Linea 7","Naranja");

UPDATE  lines 
SET name="Linea 1"
where id=1;

delete from lines 
where id=5;
```-- Escribe tu código aquí 👇SELECT \* FROM lines;INSERT INTO lines (id,name,color) VALUES ("7","Nueva Linea 7","Naranja");
UPDATE  lines SET name="Linea 1"where id=1;
delete from lines where id=5;

Gelber Johan Pachon Sierra

student•

Jeison Sanchez

student•

Hola , les comparto mi solución:

INSERT INTO lines (id, name, color) VALUES ("7", "Nueva Linea 7", "Naranja");

UPDATE lines SET name = "Linea 1" WHERE id = 1;

DELETE FROM lines WHERE id = 5;

-- Escribe tu código aquí 👇 SELECT * FROM lines;

Jesus Bautista Hurtado

student•

-- Escribe tu código aquí 👇INSERT INTO lines (id, name, color)VALUES (7, 'Nueva Linea 7', 'Naranja'); UPDATE linesSET name = 'Linea 1'WHERE id = 1; DELETE FROM linesWHERE id = 5; SELECT * FROM lines;

Hector Maluy Fernandez

student•

Mi respuesta:

INSERT INTO lines (id, name, color) VALUES (7,'Nueva Linea 7', 'Naranja');
UPDATE lines SET name = 'Linea 1' WHERE id = 1;
DELETE FROM lines WHERE id = 5;
SELECT * FROM lines;

Ulqernesh Karvenae

student•

Spoiler

Guadalupe Lima

student•

SELECT * FROM lines;

INSERT INTO `lines` (id,name,color)
VALUES (7, "Nueva Linea 7", "Naranja");

UPDATE `lines`
SET name = "Linea 1"
WHERE id = 1;

DELETE FROM `lines`
WHERE id=5;

SELECT * FROM `lines`;

Aldo Mauricio Vital Gutierrez

student•

Les comparto mi solución y aprovecho para hacer una pregunta,

¿El SET como se interpreta en el ejercicio de actualización ?

INSERT INTO 
`lines` (
  `id`, `name`, `color`
  ) 
VALUES 
(7, "Nueva Linea 7", "Naranja");

UPDATE `lines`
SET `name` = "Linea 1"
WHERE `id` = 1;  

DELETE FROM `lines`
WHERE `id` = 5;

Brandon Felipe Ortiz Herrera

student•

El set se intepreta como el lugar donde vas a realizar el cambio, por esto seleccionas la columna en este name y le agregas el nuevo dato, en este caso linea 1, ya que el WHERE no selecciona donde se va hacer el cambio, sino que funciona para limitar el cambio

Rafael Andrés Araujo Ordoño

student•

-- Escribe tu código aquí 👇SELECT * FROM lines; --crear nuevo registro de lineaINSERT INTO lines (id,name,color) VALUES(7,"Nueva Linea 7", "Naranja"); --Actualizar el registro de la linea 1UPDATE lines SET name = 'Linea 1'WHERE id = 1; --Eliminar el registro de la linea de id 5DELETE FROM linesWHERE id = 5; SELECT * FROM lines;

Cristian Felipe Diaz

student•

SELECT * FROM lines; INSERT INTO lines (id, name, color)VALUES (7, 'Nueva Linea 7', 'Naranja'); UPDATE linesSET name = 'Linea 1'WHERE id = 1; DELETE FROM linesWHERE id = 5;

Wagner Fernández

student•

Solución al problema:

--Query table
SELECT * FROM lines;

--Resolving problem one (insert data)
INSERT INTO lines (id, name, color)
VALUES (7, 'Nueva Linea 7','Naranja');

--Resolving problem two (update data)
UPDATE lines
SET name = 'Linea 1'
WHERE id = 1;

--Resolving problem three (delete data)
DELETE FROM lines
WHERE id = 5;

--Query table (test)
SELECT * FROM lines;

Vladimir Angarita

student•

-- Escribe tu código aquí 👇

SELECT * FROM lines;INSERT INTO lines (id, name, color) VALUES(7,"Nueva Linea 7" ,"Naranja");

SELECT * FROM lines;

UPDATE linesSET name="Linea 1"WHERE id=1;

SELECT * FROM lines;

DELETE FROM linesWHERE id=5;

SELECT * FROM lines;

Sebastián Andrés Sanhueza Tapia

student•

Recuerden comentar con puntos para que no se vea inmediatamente la respuesta, puesto que espoilea a los que vienen a hacer el ejercicio . . . . .

INSERT INTO `lines` (id, name, color) VALUES
(7, "Nueva Linea 7", "Naranja");

UPDATE `lines`
SET name = "Linea 1"
WHERE id = 1;

DELETE FROM `lines`
WHERE id = 5;

SELECT * FROM lines;