Updated on 2025-07-15 GMT+08:00

cursor.executemany(query,vars_list)

Description

This method executes an SQL command against all parameter sequences or mappings found in the sequence SQL.

Prototype

cursor.executemany(query,vars_list)

Parameters

Table 1 cursor.executemany parameters

Keyword

Description

query

SQL statement that you want to execute.

vars_list

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

Return Value

None

Example

For details, see Example: Common Operations.