Mysql to python pandas

import mysql.connector as sql
import pandas as pd

db_connection = sql.connect(host='hostname', database='db_name', user='username', password='password')
db_cursor = db_connection.cursor()
db_cursor.execute('SELECT * FROM table_name')

table_rows = db_cursor.fetchall()

df = pd.DataFrame(table_rows)

Source: stackoverflow.com

Mysql to python pandas

from sqlalchemy import create_engine
import pandas as pd

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)

Source: stackoverflow.com

Similar codes

0 vote452 views1 answer
Mysql get longest string in column
SQL
1 vote371 views1 answer
Alphabetical order mysql
SQL
0 vote354 views1 answer
Lesser than or equal to symbol in postgres
SQL
39 votes437 views4 answers
Select duplicates in sql
SQL
2 votes388 views1 answer
Rails execute sql
SQL
1 vote353 views1 answer
Mysql select update same table
SQL
1 vote343 views1 answer
How much every mysql database record takes from diskspace
SQL
1 vote355 views1 answer
Mysql current running queries
SQL
0 vote358 views1 answer
Oracle query archivemode
SQL
0 vote353 views1 answer
Mysqldump don't drop table
SQL