/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 vote239 views1 answer
Networkx - calculate degree per each node
Python
0 vote332 views1 answer
How to read first column of csv intro a list python
Python
0 vote295 views2 answers
Split paragraphs in python
Python
5 votes284 views3 answers
Exception get line number python
Python
7 votes275 views1 answer
How to find the location of a character in a string in python
Python
0 vote252 views1 answer
Change value in excel in python
Python
0 vote271 views1 answer
Python intitialize a 2d matrix
Python
0 vote272 views3 answers
Pandas python tutorial
Python
4 votes203 views1 answer
Datetime has no attribute now
Python
4 votes266 views3 answers
Python remove characters from end of string
Python