/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 vote225 views1 answer
Openquery update linked server
SQL
4 votes244 views2 answers
Installing sql on ubuntu
SQL
1 vote195 views1 answer
Find a column in all tables postgres
SQL
12 votes206 views4 answers
How to check mysql version ubuntu
SQL
0 vote205 views1 answer
Mysql remove bad character from all fields
SQL
3 votes210 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote185 views1 answer
Min and max salary and name in sql
SQL
0 vote226 views2 answers
How to combine two sql queries in one result
SQL
0 vote197 views1 answer
Mysql make date from 2 column
SQL
1 vote216 views1 answer
Events mysql
SQL