/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

12 votes253 views2 answers
Insert multiple rows from another table sql
SQL
0 vote260 views1 answer
DATEDIFF minute postgres
SQL
1 vote237 views1 answer
Postgresql create table with timestamp
SQL
5 votes226 views1 answer
Oracle ora-00054 causes
SQL
0 vote215 views1 answer
Sql gap missing values
SQL
3 votes261 views1 answer
Oracle function return
SQL
6 votes230 views1 answer
Sql insert values into table
SQL
0 vote215 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote240 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote223 views1 answer
Update set with join pl sql
SQL