Updated on 2024-10-14 GMT+08:00

cursor.executemany(query,vars_list)

Function

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

Prototype

cursor.executemany(query,vars_list)

Parameter

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.