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 vote262 views1 answer
How to increase the width of the screen in oracle
SQL
11 votes285 views1 answer
Oracle view ddl
SQL
1 vote294 views1 answer
Mysql size int
SQL
2 votes259 views1 answer
Match in sql server
SQL
2 votes277 views1 answer
Change primary key sql
SQL
1 vote272 views1 answer
Sql list all procedures
SQL
2 votes306 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote316 views1 answer
Stratified sampling sql
SQL
-1 vote283 views5 answers
Online sql to linq generator
SQL
0 vote304 views2 answers
Compound operator in sql
SQL