/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 vote376 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote377 views1 answer
Count in sql and diff
SQL
0 vote374 views1 answer
Sql select lowest value row
SQL
8 votes376 views1 answer
Today minus 15 days postgresql
SQL
0 vote344 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote380 views1 answer
Convert epoch to date in sql server
SQL
0 vote358 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote365 views1 answer
Sql include rows with 0 values
SQL
0 vote361 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote342 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL