%load_ext sql
%sql sqlite://
'Connected: None@None'
%%sql
CREATE TABLE writer (first_name, last_name, year_of_death);
INSERT INTO writer VALUES ('William', 'Shakespeare', 1616);
INSERT INTO writer VALUES ('Bertold', 'Brecht', 1956);
[]
%sql select * from writer
first_name | last_name | year_of_death |
---|---|---|
William | Shakespeare | 1616 |
Bertold | Brecht | 1956 |