python - sqlite3.OperationalError：“/”附近：语法错误

Question

我如何划分 2 个不同的字段，这些字段将值设置为 sqllie3 中的另一个字段

cursor.execute(f"UPDATE main SET W/L Ratio = Wins/Loss WHERE Players = {int(winner_id)}")

标签： pythonsqlpython-3.xdatabasesqlite

Answer 1

你只是错过了你的报价

cursor.execute(f'UPDATE main set "W/L Ratio" = Wins/Loss WHERE Players = {int(winner_id)}')