/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

23 votes267 views6 answers
Flask getting started
Python Flask
5 votes136 views3 answers
How to extract zip file using python
Python
2 votes187 views1 answer
Django try catch exception
Python Django
-2 votes126 views2 answers
Savefig matplotlib python
Python
-1 vote107 views1 answer
C is better than python
Python
0 vote108 views1 answer
Ansible playbook to set passwordless sudo
Python
1 vote75 views1 answer
How get 1st column in all rows of a 2d matrix in python
Python
1 vote116 views1 answer
Fastest way to output text file in python + Cout
Python
1 vote123 views1 answer
Python print how long it takes to run
Python
3 votes109 views2 answers
Python subprocess exception handling
Python