executemany(): Basic syntax

The executemany() call has the following basic syntax:

<cursor object handle>.executemany(<statement>, <arguments>)

Note that neither the statement to be processed nor its arguments is optional. Both are required; otherwise, a TypeError will be thrown by Python.

The data type of each argument to executemany() should be noted as:

• statement: A string containing the query to execute

• arguments: A sequence containing parameters to use within the statement

Using any other type for statements or arguments will result in Python throwing an error.

The statement may be constructed using Python's string manipulation methods. The sequence reflected in the arguments must be either of a sequence or mapping type. Thus, the following data types are allowed as arguments:

• strings

• lists

• tuples

• dictionaries

If a comma-delimited list is inadvertently passed as a string, it will be evaluated as a string and will not be separated. Consequently, if one is passing values for multiple...