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 vote284 views1 answer
Inner joint
SQL
0 vote306 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote304 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote322 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
2 votes296 views1 answer
Get first 2 letter in sql
SQL
1 vote307 views1 answer
Window function mysql
SQL
3 votes292 views3 answers
Concatenation in sql
SQL
11 votes319 views6 answers
Mysql else if
SQL
0 vote284 views2 answers
Install phoenix
SQL
0 vote290 views1 answer
Sql cheetsheet
SQL