/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

0 vote131 views1 answer
How to output a different column name in mysql
SQL
0 vote119 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote125 views3 answers
ChAnge TABLE name apex oracle
SQL
0 vote136 views1 answer
Java spring boot connect to sql server
SQL
1 vote155 views1 answer
Encrypt password postgresql
SQL
0 vote142 views1 answer
Php get closest location by latitude longitude
SQL
2 votes150 views1 answer
Coalesce sql
SQL
0 vote135 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
20 votes144 views6 answers
Mysql reset auto increment
SQL
0 vote133 views1 answer
Start and stop mysql
SQL