/Python/How to read mysql table in python

How to read mysql table in python

# for those who can't see all columns in the
# output when getting data from database

# just paste in the following code and that should be fixed
pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)
pd.set_option('display.width', None)
pd.set_option('display.max_colwidth', None)

How to read mysql table in python

import pandas as pd
import sqlalchemy

# make sure you have installed both mysql & pymysql

													# root:root is my username and password/default
engine = sqlalchemy.create_engine("mysql+pymysql://root:root@localhost/database name", pool_pre_ping=True)
# then specify the name of the table in the database
df = pd.read_sql_table('table name', engine)
print(df)

Source: stackoverflow.com

Similar codes

2 votes254 views1 answer
Python short circuit
Python
3 votes290 views2 answers
Install decouple python
Python
2 votes286 views1 answer
Python pip graphviz
Python
155 votes346 views6 answers
Python os if file exists
Python
0 vote273 views1 answer
Get file arg0 python
Python
0 vote296 views1 answer
Odoo order by xml rpc
Python
0 vote288 views1 answer
How to check if a key is present in python dictionary
Python
4 votes275 views1 answer
Orderd set in python
Python
0 vote285 views1 answer
Jupyter upload folder
Python
0 vote319 views1 answer
Def identity_block(X, f, filters, training=True, initializer=random_uniform):
Python