singlestoredb.connection.Cursor.execute

abstract Cursor.execute(query: str, args: Optional[Union[Sequence[Any], Dict[str, Any], Any]] = None) int

Execute a SQL statement.

Queries can use the format-style parameters (%s) when using a list of paramters or pyformat-style parameters (%(key)s) when using a dictionary of parameters.

Parameters
  • query (str) – The SQL statement to execute

  • args (Sequence or dict, optional) – Parameters to substitute into the SQL code

Examples

>>> cur.execute('select * from mytable')
>>> cur.execute('select * from mytable where id < %s', [100])
>>> cur.execute('select * from mytable where id < %(max)s', dict(max=100))
Return type

Number of rows affected