ipython_sql_sqlite_memory_table_create_and_query.py

1import pandas as pd
2import sqlalchemy
3
4# Load the ipython-sql extension
5%load_ext sql
6
7# Connect to a database (using an in-memory SQLite database in this example)
8%sql sqlite://
9
10# Execute SQL commands
11%%sql
12CREATE TABLE table1 (col1, col2);
13INSERT INTO table1 VALUES (1, 'A'), (2, 'B');
14SELECT * FROM table1;