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

5 votes173 views4 answers
Traduction
SQL
0 vote161 views2 answers
List all constraints in postgres
SQL
1 vote141 views1 answer
Set statistics on in ssms
SQL
1 vote201 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote150 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
7 votes148 views4 answers
What is my mysql version
SQL
0 vote145 views1 answer
Raiserror nowait sql server
SQL
0 vote152 views1 answer
Primary key multiple colums
SQL
0 vote138 views1 answer
Create date sql
SQL
1 vote150 views1 answer
Simple project for database
SQL