/Python/Connect to mysql database jupyter

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

1 vote315 views1 answer
Python number of elements in multidimensional array
Python
7 votes302 views2 answers
Append record in csv
Python
1 vote345 views1 answer
Django templateview
Python Django
2 votes304 views1 answer
Get n random numbers from x to y python
Python
7 votes328 views6 answers
Print two digits after decimal python
Python
0 vote328 views1 answer
How to console log in django heroku
Python
0 vote310 views1 answer
Comment transformer un chaine de caractere en liste python
Python
0 vote403 views1 answer
RuntimeError: cannot open featureclass in python
Python
0 vote373 views2 answers
Where should favicon.ico be placed in flask app
Python Flask
0 vote314 views1 answer
Boto3 read excel file from s3
Python