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

3 votes132 views2 answers
Current year sql
SQL
1 vote149 views1 answer
How to print longest name in sql
SQL
1 vote187 views1 answer
Pgsql sum switch case
SQL
0 vote150 views1 answer
Get date ISO in psql
SQL
0 vote140 views1 answer
Mysql multiple primary keys
SQL
3 votes144 views2 answers
See mysql users ubuntu
SQL
0 vote171 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote139 views1 answer
Mysql in clausule string array
SQL
0 vote162 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote146 views1 answer
Where date major today mysql
SQL