我正在嘗試更新我的資料庫。我想在運行時將 None 更改為時間
sqlite3.OperationalError: near ":59": syntax error
我要更新的代碼是：
now = datetime.now()
trigger_time = str(now.strftime("%H:%M"))
db.execute(f"""Update Signals set Triger_Time = {trigger_time} where ID = {int(signal_id)}""")
由（https://stackoverflow.com/a/69661333/16613629）解決
答案：您忘記了 Triger_Time 周圍的引號：
now = datetime.now()
trigger_time = str(now.strftime("%H:%M"))
db.execute(f"""Update Signals set Triger_Time = '{trigger_time}' where ID = {int(signal_id)}""")
uj5u.com熱心網友回復：
你忘記了 Triger_Time 周圍的引號：
now = datetime.now()
trigger_time = str(now.strftime("%H:%M"))
db.execute(f"""Update Signals set Triger_Time = '{trigger_time}' where ID = {int(signal_id)}""")
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/329511.html