/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

3 votes266 views1 answer
Starting vscode on colab
Python
0 vote314 views1 answer
Pandas dataframe caption
Python
8 votes274 views3 answers
How to playsound in python
Python
0 vote282 views1 answer
How to save string characters into char array or list in python
Python
-1 vote300 views3 answers
Count string python
Python
0 vote298 views1 answer
Blue ray size
Python
0 vote303 views1 answer
Applies the f function to all Row
Python
0 vote296 views1 answer
Python count empty lines in text file
Python
0 vote285 views1 answer
Pytorch calculate mse mae
Python
0 vote298 views1 answer
Python cache return value
Python