/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

3 votes189 views1 answer
Mysql insert on dupèlicate
SQL
5 votes184 views4 answers
Select random rows sql
SQL
0 vote180 views1 answer
Search starting with mysql
SQL
0 vote188 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
1 vote192 views1 answer
Oracle sql pad left zeros
SQL
1 vote192 views1 answer
Update mysql centos
SQL
0 vote236 views1 answer
Plpgsql create function
SQL
12 votes169 views4 answers
Mysql get date difference in hours
SQL
0 vote218 views1 answer
Sql remove decimal places
SQL
4 votes130 views1 answer
Generate class from sql table c#
SQL