singlestoredb.connection.Cursor.executemany¶
- Cursor.executemany(query: str, args: Optional[Sequence[Union[Sequence[Any], Dict[str, Any], Any]]] = None) int ¶
Execute SQL code against multiple sets of parameters.
Queries can use the
format
-style parameters (%s
) when using lists of paramters orpyformat
-style parameters (%(key)s
) when using dictionaries of parameters.- Parameters
query (str) – The SQL statement to execute
args (iterable of iterables or dicts, optional) – Sets of parameters to substitute into the SQL code
Examples
>>> cur.executemany('select * from mytable where id < %s', ... [[100], [200], [300]])
>>> cur.executemany('select * from mytable where id < %(max)s', ... [dict(max=100), dict(max=100), dict(max=300)])
- Return type
Number of rows affected