/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 vote198 views1 answer
Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly
Python
0 vote181 views1 answer
Django template date format yyyy-mm-dd
Python Django
0 vote214 views1 answer
What are data types in python
Python
0 vote222 views1 answer
Count upercase
Python
0 vote232 views1 answer
Cv2.imwrite save to folder
Python
44 votes231 views6 answers
Pandas read csv file
Python
0 vote229 views1 answer
Integer to boolean numpy
Python
0 vote237 views2 answers
Pd is not defined python error
Python
0 vote241 views1 answer
Python log with timestamp
Python
-1 vote250 views2 answers
How to declare tuple in python
Python