Twice now, at step 6 of Learn SQL | Codecademy, when I execute an incorrect statement, the SQL query results window goes blank and I’m unable to recover.
Below is the code of my second go round (I hit the reset after the first instance) The issue occurs when I execute the line
update table friends name = 'storm' where id = 1;. the lines after that are my attempt to recover, but the query results window remains blank. Although I the line is out of order from the instructions, I wouldn’t think that would be an issue in this case.
create table friends ( id integer, name text, birthday date ); insert into friends (id, name, birthday) values (1, 'Ororo Munroe', '1940-05-30'); select * from friends; insert into friends (id, name, birthday) values (2, 'James Taylor', '1940-06-12'), (3, 'Mark Dodd', '1960-03-05'); select * from friends; alter table friends add email text; update table friends name = 'storm' where id = 1; update table friends set name = 'storm' where id = 1; select * from friends;