我有一個關于使用 sqlalchemy/python(3.8) 將變數注入 sql 查詢的問題。
到目前為止我研究的是添加 %s 和 email_address=? 然后添加它（email_address）但沒有成功
我想要做的是捕獲用戶輸入并動態運行選擇查詢。
print(" What is the email address??")
email_address = input()
conn = create_engine("mssql pyodbc://test_table:[email protected]:3306/test_db?driver=SQL Server?Trusted_Connection=yes'", echo = False)
sql = pd.read_sql('Select id,email_address from test_table where email_address = email_address', conn)
print(sql)uj5u.com熱心網友回復：
嘗試：
print(" What is the email address??")
email_address = input()
conn = create_engine("mssql pyodbc://test_table:[email protected]:3306/test_db?driver=SQL Server?Trusted_Connection=yes'", echo = False)
sql = pd.read_sql('Select id,email_address from test_table where email_address = %(email_address)s', conn, params={"email_address": email_addres})
print(sql)
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/320749.html
標籤：Python sql 变量 sqlalchemy 用户输入