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 vote96 views1 answer
Min:sec datediff mssql
SQL
0 vote106 views1 answer
Select * from mysql.proc
SQL
0 vote98 views2 answers
Uninstall postgresql mac
SQL
0 vote107 views1 answer
Declare or use variable in snowflake
SQL
2 votes103 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
-1 vote118 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
48 votes164 views3 answers
Psql create database
SQL
1 vote98 views2 answers
Create a unqie constraint mysql
SQL
0 vote147 views1 answer
Having all mysql
SQL
1 vote109 views3 answers
Mysql disable foreign keys check
SQL