Project: Create a table | Codecademy | Analyze data with SQL | 1. Getting started with SQL | Manipulation

create_a_table.txt

CREATE TABLE friends (
   id INTEGER,
   name TEXT,
   birthday DATE
);

INSERT INTO friends
VALUES (1, 'Jane Doe', 1990-05-30);

SELECT *
FROM friends;

INSERT INTO friends
VALUES (2, 'Vu Minh', 1993-08-27);

INSERT INTO friends
VALUES (2, 'Hai Son', 1993-03-18);

UPDATE friends
SET name = 'Jane Smith'
WHERE ID = 1;

ALTER TABLE friends
ADD COLUMN email TEXT;

UPDATE friends
SET email = 'jane@codecademy.com'
WHERE id = 1;

DELETE FROM friends
WHERE id = 1;

SELECT *
FROM friends;