Mysql connection with sqlalchecmy

import pandas as pd
import pymysql
from sqlalchemy import create_engine

cnx = create_engine('mysql+pymysql://<username>:<password>@<host>/<dbname>')    
df = pd.read_sql('SELECT * FROM <table_name>', cnx) #read the entire table

Source: stackoverflow.com

Similar codes

14 votes103 views2 answers
How to auto increment in sql
SQL
0 vote132 views1 answer
Get total and distict row diff in sql
SQL
0 vote109 views1 answer
Selecting duplicates
SQL
0 vote149 views1 answer
Creating sqeuence in oracle database
SQL
1 vote103 views1 answer
Get table column names sql ssms
SQL
0 vote107 views1 answer
How to update date value in sql
SQL
0 vote101 views1 answer
Sql change column in existing table
SQL
5 votes120 views1 answer
How to get all table names in sql query
SQL
0 vote99 views1 answer
Sql view index
SQL
1 vote107 views1 answer
Show all event schedular on mysql
SQL