/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 vote100 views1 answer
Media sql
SQL
-1 vote104 views1 answer
How to open blade file from blade in laravel
SQL
5 votes105 views2 answers
Oracle list columns
SQL
49 votes175 views6 answers
Get duplicate records in sql
SQL
0 vote98 views2 answers
Nosqlbooster query other collection
SQL
0 vote109 views1 answer
Mysql check datetime equals date
SQL
0 vote103 views2 answers
How to check if a column exists in a SQL Server table?
SQL
2 votes103 views1 answer
Mysql set value as null
SQL
3 votes105 views5 answers
No module named 'MySQLdb'
SQL
8 votes110 views2 answers
Oracle undo usage
SQL