/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

6 votes95 views3 answers
Media url django
Python
3 votes145 views3 answers
Simple jwt django
Python
18 votes90 views2 answers
Check if variable is defined
Python
0 vote100 views1 answer
PHP echo multiple lines example Using concatenation assignment operator
Python
0 vote97 views3 answers
Python ascii to string
Python
0 vote117 views1 answer
Minimum of two columns in pandas
Python
0 vote94 views2 answers
Numpy method to make polynomial model
Python
0 vote90 views1 answer
Number of spaes pythopn
Python
0 vote106 views1 answer
Leetcode 206 python
Python
0 vote97 views1 answer
MIn-Max problem in python
Python