MySQL Check Version
mysql_check_versionRead-only
Read the current version of a row for optimistic concurrency control. Prevents conflicting updates by checking row version before making changes.
Instructions
Read the current _version of a specific row for optimistic concurrency control.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | No | Alias for rowId | |
| name | No | Alias for table | |
| rowId | No | Primary key value of the row | |
| table | No | Table containing the row | |
| idColumn | No | Primary key column name. Defaults to 'id' if not provided. | |
| tableName | No | Alias for table |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| code | No | Error code (e.g. VALIDATION_ERROR, QUERY_ERROR) | |
| data | No | ||
| error | No | Error message if operation failed | |
| details | No | Additional error context | |
| metrics | No | Token estimation metrics | |
| success | Yes | Whether the operation succeeded | |
| category | No | Error category (validation, query, connection, internal) | |
| suggestion | No | Suggested fix for the error | |
| recoverable | No | Whether the error is recoverable |