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 vote124 views1 answer
Import local sql into remote mysql
SQL
5 votes137 views3 answers
Postgres show databases
SQL
2 votes152 views1 answer
Oracle trace file
SQL
23 votes157 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote139 views1 answer
Change role postgres
SQL
6 votes149 views1 answer
Allsource oracle
SQL
44 votes211 views6 answers
Rename command in sql
SQL
0 vote144 views1 answer
New rails app with mysql
SQL
1 vote149 views1 answer
Drop primary key oracle
SQL
0 vote139 views1 answer
Column ' ' in field list is ambiguous
SQL