SQL BASICS SPANISH DOC

-- CREANDO LA TABLA Y LOS PARAMETROS
CREATE TABLE friends (
  id INTEGER,
  name TEXT,
  birthday DATE
);
-- INSERTAR DATOS INICIALES
INSERT INTO friends (id, name, birthday)
VALUES (1, 'Ororo Munroe', '1940-05-30' );
VALUES (2, 'Ivan Perez', '2006-08-31' );
VALUES (3, 'Fabio Perez', '2003-05-15' );


--ALTERAR TABLA Y AGREGAR COLUMNA
ALTER TABLE friends
ADD COLUMN email TEXT;

--ACTUALIZAR DATOS
UPDATE friends
SET name = 'Storm'
WHERE id = 1;


--AGREGAR DATOS A LA COLUMNA NUEVA

UPDATE friends
SET email = '[email protected]'
WHERE id = 2;

UPDATE friends
SET email = '[email protected]'
WHERE id = 3;

UPDATE friends
SET email = '[email protected]'
WHERE id = 1;


--REMOVER DATOS
DELETE FROM friends
WHERE id = 1;

SELECT *
FROM friends;