Updated on 2025-10-23 GMT+08:00

cursor.executemany(query,args)

Description

This method can be used to execute multiple parameterized SQL statements.

Prototype

cursor.executemany(query,args)

Parameters

Table 1 cursor.executemany

Keyword

Parameter Description

query

SQL statement that you want to execute.

args

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

Return Value

None

Constraints

cursor.executemany(query,args) does not use \0 in the entered SQL statement.

Examples

For details, see Examples: Common Operations.