/SQL/Jupyter notebook connect to database

Jupyter notebook connect to database

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

9 votes203 views5 answers
Sql delete duplicate rows but keep one
SQL
2 votes193 views1 answer
Oracle number to percentage
SQL
0 vote197 views1 answer
Flask sqlalchemy update row
SQL
0 vote210 views1 answer
Désinstaller postgresql linux
SQL
4 votes167 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote187 views1 answer
Create table employees oracle
SQL
0 vote210 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote241 views1 answer
Oracle decode
SQL
7 votes221 views2 answers
How to create index mysql
SQL
7 votes201 views3 answers
Sql fill table with info from anothe rtable
SQL