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

25 votes173 views1 answer
Mysql grant all privileges to a user
SQL
0 vote176 views1 answer
Access mysql database docker container shell
SQL
0 vote181 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote222 views1 answer
Select year from dual oracle
SQL
0 vote187 views1 answer
Sql server list user permissions
SQL
0 vote187 views4 answers
How to get max salary in each department in sql
SQL
0 vote182 views1 answer
Sql alter column name sql server
SQL
51 votes298 views6 answers
Opera gx
SQL
0 vote187 views1 answer
SQL add a totals of differemt rows of the same id
SQL
2 votes148 views1 answer
Sql select in list
SQL