Basic SQL Manipulation
Wed Sep 27 2023 02:46:38 GMT+0000 (Coordinated Universal Time)
Saved by
@cruz
CREATE TABLE friends (
id INTEGER,
name TEXT,
birthday DATE
);
INSERT INTO friends (id,name, birthday)
VALUES (1,'Ororo Munroe', 'May 30th, 1940');
INSERT INTO friends (id,name, birthday)
VALUES (2,'Edward Nylander', 'July 30th, 1958');
INSERT INTO friends (id,name, birthday)
VALUES (3,'Taylor Olson', 'February 20th, 1958');
UPDATE friends
SET name = 'Storm'
WHERE id = 1;
ALTER TABLE friends
ADD email TEXT;
UPDATE friends
SET email = 'storm@codeacademy.com'
WHERE id = 1;
UPDATE friends
SET email = 'randomnumber@mst.edu'
WHERE id = 2;
UPDATE friends
SET email = 'manimissmydawgs@gmail.com'
WHERE id = 3;
--DELETE FROM friends
--WHERE id = 1;
SELECT * FROM friends;
content_copyCOPY
https://www.codecademy.com/learn/paths/bi-data-analyst/tracks/dsf-learn-sql/modules/dsinf-learn-sql-manipulation/cheatsheet
https://www.youtube.com/watch?v=nwLV5Txc8jM&ab_channel=Codecademy
Comments