Python mysql query to dataframe

from sqlalchemy import create_engine
import pymysql

db_connection_str = 'mysql+pymysql://mysql_user:mysql_password@mysql_host/mysql_db'
db_connection = create_engine(db_connection_str)

df = pd.read_sql('SELECT * FROM table_name', con=db_connection)

# This works with "mysql.connector" as well

Source: stackoverflow.com

Similar codes

1 vote255 views1 answer
How to see all table partition in oracle
SQL
0 vote233 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
7 votes250 views1 answer
Mysql unsafe update
SQL
0 vote257 views1 answer
Java input type sql date
SQL
9 votes283 views1 answer
No sql
SQL
0 vote271 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
5 votes296 views1 answer
Sql integer to serial
SQL
1 vote265 views5 answers
Sql 2nd highest salary
SQL
0 vote277 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote238 views1 answer
Unique vs distinct sql
SQL