-
Book Overview & Buying
-
Table Of Contents
MySQL for Python
By :
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...
Change the font size
Change margin width
Change background colour