/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

2 votes148 views1 answer
Get current time in python with strftime
Python
0 vote156 views1 answer
How to make a number guessing game in python
Python
1 vote162 views2 answers
Round python print
Python
8 votes143 views1 answer
Expand all rows pandas
Python
3 votes146 views4 answers
Python list group by count
Python
10 votes159 views9 answers
Google traduction
Python
0 vote172 views1 answer
How to draw play area for a game in python turtle
Python
19 votes121 views2 answers
Install selenium python
Python
14 votes159 views4 answers
Python pip jupyter notebook install
Python
1 vote179 views1 answer
Python remove n random elements from a list
Python