/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

97 votes169 views5 answers
How to make a python exe
Python
0 vote169 views1 answer
How to check nth prime in python
Python
0 vote142 views1 answer
Python write list to excel file
Python
1 vote129 views1 answer
Python return right operand if left is falsy
Python
14 votes144 views5 answers
How to create requirements.txt django
Python
0 vote150 views1 answer
Change a color on touch roblox
Python
19 votes148 views6 answers
Pandas change column order
Python
0 vote184 views1 answer
Django MESSAGE_TAGS
Python Django
22 votes111 views2 answers
How to drop a row in pandas
Python
0 vote152 views1 answer
Configparser error reading relative file path
Python