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

11 votes111 views1 answer
Oracle view source
SQL
0 vote108 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote106 views1 answer
Procedures sql insert mysql
SQL
5 votes113 views2 answers
Oracle find all tables with column name
SQL
0 vote116 views1 answer
How to input data as id in database sql c#
SQL
1 vote165 views1 answer
Primary key reset in SQL database
SQL
4 votes135 views5 answers
Get last query in codeigniter 4
SQL
0 vote111 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote109 views1 answer
Mysql select where field like in list
SQL
0 vote109 views1 answer
Php mysqli install
SQL