Help Center/ GaussDB/ Developer Guide(Distributed_3.x)/ Application Development Guide/ Psycopg-based Development/ Psycopg API Reference/ cursor.execute(query,vars_list)
Updated on 2024-05-07 GMT+08:00
View PDF
Share

cursor.execute(query,vars_list)

Function

This method executes the parameterized SQL statements (that is, placeholders instead of SQL literals). The psycopg2 module supports placeholders marked with %s.

Prototype

curosr.execute(query,vars_list)

Parameters

Table 1 curosr.execute parameters

Keyword

Description

query

SQL statement to be executed.

vars_list

Variable list, which matches the %s placeholder in the query.

Return Value

None

Example

For details, see Examples: Common Operations.

Parent topic: Psycopg API Reference