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

20 votes241 views1 answer
Sql change column types
SQL
0 vote229 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
3 votes253 views2 answers
Update part of a string in mysql
SQL
3 votes221 views1 answer
Oracle nextval
SQL
0 vote231 views1 answer
Add SuperUser MySQL
SQL
8 votes239 views1 answer
Script to add datafile to tablespace
SQL
0 vote255 views1 answer
Mariadb change column type
SQL
0 vote194 views1 answer
Update row in sqlite python
SQL
0 vote241 views1 answer
Mariadb select limit offset
SQL
0 vote224 views1 answer
How to find top 3 salary in sql
SQL