select a table in the db and show info from this table:
SELECT * FROM celebs;
create DB table:
CREATE TABLE celebs (id INTEGER, name TEXT, age INTEGER);
insert info into DB:
INSERT INTO celebs (id, name, age) VALUES (1, 'Justin Bieber', 21);
INSERT INTO celebs (id, name, age) VALUES (2, 'Beyonce Knowles', 33);
INSERT INTO celebs (id, name, age) VALUES (3, 'Jeremy Lin', 26);
INSERT INTO celebs (id, name, age) VALUES (4, 'Taylor Swift', 26);
update a row in the DB
UPDATE celebs
SET age = 22
WHERE id = 1;
SELECT * FROM celebs;
Add a new column to the table
ALTER TABLE celebs ADD COLUMN twitter_handle TEXT;
SELECT * FROM celebs;
add information to this new column
UPDATE celebs
SET twitter_handle = '@taylorswift13'
WHERE id = 4;
SELECT * FROM celebs;
delete rows that have a NULL value
UPDATE celebs
SET twitter_handle = '@taylorswift13'
WHERE id = 4;
DELETE FROM celebs WHERE twitter_handle IS NULL;
SELECT * FROM celebs;