/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

0 vote321 views1 answer
How to specify port while running django project
Python Django
0 vote286 views1 answer
Django custome login
Python
6 votes276 views2 answers
Convert negative to positive in python
Python
0 vote300 views1 answer
Transform image to rgb python
Python
0 vote294 views1 answer
Request.body django
Python Django
30 votes286 views6 answers
Django static files
Python
0 vote284 views1 answer
Template tag django
Python
0 vote289 views1 answer
Discord.File(fp=image_binary,filename=name) discord py
Python
16 votes277 views4 answers
List to dataframe columns
Python
0 vote280 views1 answer
Customizable TKinter Buttons Python
Python