/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 vote114 views2 answers
Py search and get objects from array
Python
8 votes111 views3 answers
Python gzip file
Python
4 votes114 views3 answers
How to get a character from a string in python
Python
2 votes147 views2 answers
Django-admin command not found
Python Django
0 vote147 views1 answer
TypeError: Direct assignment to the forward side of a many-to-many set is prohibited. Use .set() instead
Python
4 votes110 views3 answers
ArrayField in Django
Python
8 votes132 views1 answer
Show more columns / rows of a Pandas DataFrame
Python
0 vote121 views1 answer
Pandas print nonzero in series
Python
0 vote124 views1 answer
Pytesseract pdf to text
Python
32 votes128 views6 answers
Time a function python
Python