/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

2 votes230 views1 answer
Sql server case sensitive search
SQL
2 votes226 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
8 votes202 views3 answers
Mysql alter table add index
SQL
0 vote213 views4 answers
Mysql replace regex
SQL
0 vote212 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote265 views1 answer
Pl sql join 3 tables
SQL
0 vote235 views1 answer
How to check database engine in mysql
SQL
0 vote224 views1 answer
Utiliser sql ligne de commande
SQL
0 vote232 views1 answer
How to start my sql server on mac
SQL
0 vote308 views1 answer
Oracle db timestamp auto add
SQL