/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 vote282 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
2 votes268 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
1 vote264 views1 answer
Mysql workbench in ubuntu 14.04
SQL
10 votes252 views2 answers
Sql rtrim
SQL
0 vote218 views1 answer
Create duplicate table in postgresql
SQL
1 vote248 views2 answers
Sql select only first occurrence
SQL
0 vote254 views1 answer
Sql not exists
SQL
1 vote271 views1 answer
Oracle grant select on schema
SQL
6 votes258 views1 answer
Oracle trigger after logon on schema
SQL
2 votes246 views1 answer
Drop table if exists in postgres
SQL