/SQL/Jupyter notebook connect to database

Jupyter notebook connect to database

Connect to mysql database jupyter

# In the python cmd, install packages:
pip3 install pymysql
pip3 install ipython-sql
pip3 install mysqlclient

# in the jupyter notebook:
import pymysql
import pandas as pd

conn=pymysql.connect(host='localhost',port=int(3306),user='root',passwd='YOUR_PASSWORD',db='YOUR_DATABASENAME')

df=pd.read_sql_query("SELECT * FROM 'YOUR_TABLENAME' ",conn)

print(df)

Source: stackoverflow.com

How to connect mysql database in jupyter notebook

# %%
%load_ext sql

# %%
%sql mysql+mysqldb://<user>:<password>@localhost/<dataBase>

# %%
%%sql

SELECT *
FROM <table>;

Source: stackoverflow.com

Similar codes

0 vote275 views1 answer
Add column not null with default value postgres
SQL
1 vote290 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote316 views1 answer
Sql date with year
SQL
0 vote311 views1 answer
Sqlite unique multiple columns
SQL
1 vote340 views1 answer
Best configuration for display table in sqlplus
SQL
6 votes284 views3 answers
Mysql change auto_increment start value
SQL
0 vote300 views1 answer
Mssql disable foreign key constraint
SQL
0 vote299 views1 answer
Java nosql sort
SQL
0 vote282 views1 answer
How to create a new shema using query languaage
SQL
0 vote300 views1 answer
Repeatable read trong sql server
SQL