Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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"""))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement