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

18 votes357 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote344 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote340 views1 answer
Mysql grant access to one database
SQL
0 vote355 views1 answer
How to get data from 2 database
SQL
5 votes344 views2 answers
Add column postgres with default value
SQL
0 vote374 views1 answer
Sql query to force the database to be drop
SQL
0 vote380 views1 answer
Querry mysql by 2 columns
SQL
0 vote343 views1 answer
Utiliser sql ligne de commande
SQL
8 votes346 views4 answers
Mysql update one table from another table multiple columns
SQL
14 votes370 views3 answers
Trim sql
SQL