/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

8 votes295 views2 answers
Determinant of matrix in python
Python
0 vote337 views1 answer
Django get all model fields
Python Django
0 vote308 views2 answers
How to refresh page in flask
Python
0 vote307 views1 answer
Example of input int questions in python with if statement
Python
0 vote303 views1 answer
What is tf.repeat()
Python
2 votes298 views1 answer
Python3 seek
Python
0 vote306 views1 answer
How can I keep the pyqt GUI responsive when performing a cpu intensive task?
Python
0 vote339 views1 answer
Tkmessagebox not found
Python
0 vote344 views1 answer
Django queryset all objects
Python Django
0 vote344 views1 answer
Is assimilation part of digestive system
Python