/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

0 vote213 views1 answer
How to change the type of a values in list from str to object python
Python
3 votes209 views4 answers
Django setup in windows
Python Django
0 vote237 views1 answer
Tabpy Configuration file with custom settings
Python
0 vote277 views4 answers
"%(class)s" in django
Python Django
3 votes203 views1 answer
Numpy factorial
Python
-2 votes195 views2 answers
How to count substring in a string in python
Python
21 votes213 views2 answers
Run python file using python code
Python
0 vote202 views1 answer
How to insert files in tuple python
Python
0 vote194 views1 answer
How to access pandas column
Python
15 votes193 views4 answers
Make a condition statement on column pandas
Python