/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 vote166 views1 answer
Implicit inner join table alias with id values
SQL
0 vote214 views1 answer
Capabilities of sql select statements
SQL
0 vote170 views1 answer
Dns slave zone convert
SQL
0 vote178 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote166 views1 answer
Index a database column sql
SQL
7 votes174 views4 answers
What is my mysql version
SQL
0 vote176 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
1 vote169 views1 answer
Rermove categories woocommerce sql
SQL
0 vote227 views1 answer
Postgres rename database
SQL
0 vote166 views1 answer
How to set all the min and sec data to zero in sql server
SQL