singlestoredb.connection.Cursor.execute

abstract Cursor.execute(query: str, args: Sequence[Any] | Dict[str, Any] | Any | None = None, infile_stream: RawIOBase | TextIOBase | Iterator[bytes | str] | Queue[bytes | str] | None = 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

• infile_stream (io.RawIOBase or io.TextIOBase or Iterator[bytes|str], optional) – Data stream for LOCAL INFILE statement

Examples

Query with no parameters

>>> cur.execute('select * from mytable')

Query with positional parameters

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

Query with named parameters

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

Return type:

Number of rows affected