Record: ExecutionResult

The result of the query without returning the rows.

Fields

  • affectedRowCount int
  • Number of rows affected by the execution of the query. It may be one of the following, (1) A number greater than or equal to zero -- indicates that the command was processed successfully and is the affected row count in the database that were affected by the command's execution (2) A value of the SUCCESS_NO_INFO indicates that the command was processed successfully but that the number of rows affected is unknown (3) A value of the EXECUTION_FAILED indicated the specific command that failed. This can be returned in sql:BatchExecuteError and only if the driver continues to process the statements after the error occurred

  • lastInsertId string | int?
  • The integer or string generated by the database in response to a query execution. Typically this will be from an auto increment column when inserting a new row. Not all databases support this feature, and thereby, it can also be ()