/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

9 votes275 views3 answers
Pygame key pressed once
Python
-1 vote255 views2 answers
Write a python program to multiplies all the items in a list.
Python
2 votes292 views1 answer
Ln in python
Python
25 votes229 views4 answers
Python iterate directory
Python
0 vote254 views1 answer
Print nested dictionary values in python
Python
72 votes276 views6 answers
Python loop array
Python
89 votes243 views6 answers
Requirements.txt python
Python
0 vote238 views1 answer
Import re #your code goes here number=input() pattern=r"(1|8|9)[0-9]+" match=re.match(pattern,number) of lane(number)==8: if(match): print("value") else: print("invalid") else print("invalid")
Python
6 votes261 views2 answers
AttributeError: type object 'Callable' has no attribute '_abc_registry'
Python
0 vote256 views1 answer
Scaling pkl file?
Python