连接数据库

gistfile1.txt

from sqlalchemy import create_engine, text
from sqlalchemy.engine.url import URL

url=URL(drivername='mysql+pymysql', username='root', password="123", host="localhost",
        port=3306, database="bi_dev")

engine = create_engine(url)



query_result = engine.execute(
    text("""SELECT user_id, display_name FROM bi_user limit 100"""))