/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 vote206 views1 answer
Plt.plot(x, softmax(scores).T, linewidth=2)
Python
0 vote220 views1 answer
Pip img2pdf
Python
1 vote197 views1 answer
Python convert list to dict with index
Python
0 vote200 views1 answer
Colorbar font size python
Python
4 votes197 views1 answer
Print specific list item python
Python
34 votes177 views1 answer
Python main file with class
Python
3 votes194 views2 answers
Import file from parent directory python
Python
0 vote248 views1 answer
Use colabs gpu locally
Python
1 vote206 views1 answer
Assigning multiple values
Python
1 vote186 views1 answer
Import mean squared log error
Python