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

25 votes448 views4 answers
Import mysql dump command line
SQL
0 vote335 views1 answer
Oracle index hint multiple tables example
SQL
12 votes367 views1 answer
Docker mysql random root password
SQL
0 vote371 views1 answer
Adding generated time in row mysql workbench
SQL
1 vote350 views1 answer
How to truncate a table in databse
SQL
4 votes328 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote373 views1 answer
Excel vba import data to sql server
SQL
0 vote335 views1 answer
Procedures and functions in pl/sql
SQL
10 votes374 views4 answers
Drop primary key
SQL
-1 vote340 views2 answers
Full join sql
SQL