/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 vote351 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote355 views2 answers
Mysql row_number() example
SQL
0 vote359 views2 answers
Advantages of stored procedures sql
SQL
0 vote336 views1 answer
Sql remove first character from string
SQL
1 vote334 views1 answer
Oracle first row
SQL
0 vote336 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
2 votes367 views1 answer
Mysql application.properties spring boot
SQL
0 vote797 views2 answers
Zsh: command not found: mysq
SQL
3 votes371 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
8 votes361 views2 answers
Select table column name in sql
SQL