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 vote332 views1 answer
Sqlplus change user
SQL
0 vote331 views2 answers
How to get last inserted id in sql server c#
SQL
1 vote297 views2 answers
Delete auto increment mysql
SQL
0 vote324 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote366 views1 answer
Least spark sql
SQL
0 vote329 views1 answer
Where case insensitive like mysql
SQL
0 vote322 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
2 votes343 views1 answer
Laravel sql String
SQL
0 vote356 views1 answer
Repeatable read trong sql server
SQL
0 vote352 views2 answers
Oracle ora-00054 how to unlock
SQL