Preparation de l'environnement¶

Via Jupyter notebook¶

Installer l'extension ipython-sql:

pip install ipython-sql

In [ ]:

%load_ext sql
%sql sqlite:///ma_base.db

%load_ext sql %sql sqlite:///ma_base.db

In [4]:

%%sql
SELECT *
FROM utilisateurs
WHERE age > 30

%%sql SELECT * FROM utilisateurs WHERE age > 30

 * sqlite:///ma_base.db
(sqlite3.OperationalError) no such table: utilisateurs
[SQL: SELECT *
FROM utilisateurs
WHERE age > 30]
(Background on this error at: https://sqlalche.me/e/20/e3q8)