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 vote197 views1 answer
Mysql start of today
SQL
0 vote208 views1 answer
Create column that already exists mysql
SQL
4 votes221 views2 answers
Mysql delete user if exists
SQL
0 vote154 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote197 views1 answer
Dump only data
SQL
3 votes193 views1 answer
What is having clause
SQL
0 vote212 views1 answer
Python connect to mysql in settings.py
SQL
4 votes198 views1 answer
Find tables with column name in sql
SQL
1 vote196 views1 answer
Get table column names sql ssms
SQL
0 vote197 views1 answer
Datetime postgres typeorm
SQL