/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

-1 vote160 views3 answers
Psql get last rows
SQL
0 vote154 views1 answer
Number(10 2) in sql means
SQL
2 votes152 views1 answer
Sql server case sensitive search
SQL
11 votes161 views1 answer
Creating tables in sql with python
SQL
12 votes159 views2 answers
Delete all entries postgres
SQL
1 vote165 views1 answer
Mysql select from outside
SQL
0 vote188 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote207 views1 answer
Add time to date sql
SQL
11 votes153 views4 answers
Query DISTINCT
SQL
0 vote155 views1 answer
Uncomment listen_address=localhost
SQL