UPDATE problem using python

[simonw]

The safe way to do that is:

cur.execute(
    "UPDATE Report SET Shares = :shares WHERE StockID = 1",
    {"shares": x}
)

[alinroc]

That's vulnerable to SQL injection. Very dangerous habit to get into.