In this project, I will create my own friends table and add/delete data from it!
- id that stores INTEGER
- name that stores TEXT
- birthday that stores DATE
Her birthday is May 30th, 1940.
SELECT *
FROM friends;
Check for two things:
-
Is friends table created?
-
Is Ororo Munroe added to it?
Insert an id, name, and birthday for each of them.
-
Ororo Munroe just realized that she can control the weather and decided to change her name. Her new name is “Storm”.
-
Update her record in friends.
Storm's email is [email protected].
Remove her from friends.
SELECT *
FROM friends;