/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

1 vote136 views2 answers
To float python
Python
0 vote159 views1 answer
Sprints for fat loss
Python
0 vote171 views2 answers
Go to python
Python
23 votes223 views3 answers
How to print a random part of a list in python
Python
0 vote164 views1 answer
Get data from model with field name in django
Python
1 vote175 views1 answer
How to obtain the content of brackets
Python
1 vote125 views1 answer
What is .new() is used in python
Python
0 vote211 views1 answer
KivyMD video recording
Python
0 vote186 views1 answer
Range all columns of df such that the minimum value in each column is 0 and max is 1. in pandas
Python
0 vote183 views1 answer
Torch.nn.Linear(in_features, out_features, bias=True) discription
Python