mysqlx.InsertStatement

class mysqlx.InsertStatement(table, *fields)

Bases: mysqlx.statement.WriteStatement

A statement for insert operations on Table.

Parameters:
  • table (mysqlx.Table) – The Table object.
  • *fields – The fields to be inserted.
changed

True if this statement has changes.

Type:bool
deallocate_prepare_execute

True to deallocate + prepare + execute statement.

Type:bool
exec_counter

The number of times this statement was executed.

Type:int
execute()

Execute the statement.

Returns:Result object.
Return type:mysqlx.Result
get_values()

Returns the list of values.

Returns:The list of values.
Return type:list
increment_exec_counter()

Increments the number of times this statement has been executed.

is_doc_based()

Check if it is document based.

Returns:True if it is document based.
Return type:bool
prepared

True if this statement has been prepared.

Type:bool
repeated

True if this statement was executed more than once.

Type:bool
reset_exec_counter()

Resets the number of times this statement has been executed.

schema

The Schema object.

Type:mysqlx.Schema
stmt_id

Returns this statement ID.

Returns:The statement ID.
Return type:int
target

The database object target.

Type:object
values(*values)

Set the values to be inserted.

Parameters:*values – The values of the columns to be inserted.
Returns:InsertStatement object.
Return type:mysqlx.InsertStatement