Answers for "mysql connection with sqlalchecmy"

SQL
0

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
Posted by: Guest on October-12-2021

Code answers related to "mysql connection with sqlalchecmy"

Code answers related to "SQL"

Browse Popular Code Answers by Language