/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 vote316 views1 answer
Check pd.NaT python
Python
20 votes363 views3 answers
Convert a number column into datetime pandas
Python
13 votes311 views6 answers
Read pickle file
Python
0 vote336 views1 answer
Gnome-shell turn off
Python
8 votes347 views4 answers
Glob
Python
0 vote327 views1 answer
Python pipe where
Python
32 votes352 views2 answers
Drop if nan in column pandas
Python
0 vote325 views1 answer
Vreverse all elemetns of a list in place python
Python
0 vote321 views1 answer
Get center position of countries geopandas
Python
-2 votes335 views2 answers
Where to import reverse_lazy in django
Python