Everything in my code worked fine until the ALTER TABLE line, and then I get no results when I save. I tried changing it to
ALTER TABLE friends
ADD email TEXT;
Any thoughts?
CREATE TABLE friends(
id INTEGER,
name TEXT,
birthday DATE);
INSERT INTO friends
VALUES (1, 'Ororo Munroe', '1940-05-30');
SELECT * FROM friends;
INSERT INTO friends
VALUES (2, 'JJ Jetplane', '1988-05-21');
INSERT INTO friends
VALUES (3, 'Ryan V', '1984-06-22');
SELECT * FROM friends;
UPDATE friends
SET name = "Storm"
WHERE id=1;
SELECT * FROM friends
ALTER TABLE friends
ADD COLUMN email TEXT;
SELECT * FROM friends