I need to run a query like this: t.update([t.code], [t.code + 1]) In response, I receive a message: psycopg2.errors.SyntaxError: syntax error at or near "%" UPDATE "t" AS "a" SET "code" = ("a"."code" + %s)

[image] bell: The following code doesn’t work: Of course it is missing the parameters of both queries. You should execute: cursor.execute(query, query1.params + query2.params) But generally python-sql does not support DDL but only DML because the first is not really standardized.

Previous table column value in update query

Support Developer

ced (Cédric Krier) Split this topic June 2, 2022, 2:43pm 9

A post was split to a new topic: Use temporary table

Topic		Replies	Views
Use temporary table Developer	5	284	June 2, 2022
Scalar subquery in limit clause Developer python-sql	5	684	June 6, 2022
Pymssql and python-sql error: alias not allowed in update insert query Developer python-sql	4	577	September 15, 2022
Quotes in generated code Developer python-sql	2	716	December 10, 2021
Is this a bug in python-sql? Developer python-sql	3	76	May 1, 2025

Previous table column value in update query

Related topics