/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 vote132 views1 answer
How to count with except in psql
SQL
0 vote139 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote139 views1 answer
Sql contains vs like
SQL
0 vote144 views1 answer
Oracle sql add column auto generated value
SQL
0 vote149 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
4 votes171 views2 answers
Oracle unliock account
SQL
0 vote150 views1 answer
Psql check table fields
SQL
0 vote158 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote127 views1 answer
How to stop all connections to a psql 12 database?
SQL
2 votes130 views1 answer
Get first 2 letter in sql
SQL