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

0 vote122 views1 answer
Import Data in MySQL without using any other software
SQL
1 vote106 views1 answer
Oracle lock user
SQL
0 vote69 views1 answer
Alter session set nls_language french
SQL
1 vote124 views3 answers
Nth highest salary
SQL
0 vote139 views1 answer
How to to get time in sql
SQL
0 vote127 views1 answer
Alter database name script
SQL
0 vote119 views1 answer
Plpgsql raise notice
SQL
0 vote117 views1 answer
Postgres read table structure
SQL
0 vote122 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote114 views1 answer
Get current date data in mysql
SQL