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

1 vote250 views1 answer
Alter constraint postgres
SQL
1 vote200 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote143 views1 answer
Mariadb set vertical output format
SQL
0 vote117 views1 answer
Mysql workbench search all tables
SQL
0 vote121 views1 answer
Oracle sql replace string in clob
SQL
1 vote143 views1 answer
Sql alchemy with azuresql server
SQL
15 votes144 views2 answers
Install mysql 8 ubuntu 18.04
SQL
1 vote175 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
2 votes153 views6 answers
In in sql
SQL
2 votes169 views3 answers
Row number mysql
SQL