MySQL CONCAT
mysql_concatRead-only
Concatenate values from multiple columns into one string with a custom separator, useful for combining fields directly in a MySQL query.
Instructions
Concatenate multiple columns with an optional separator.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | Alias for table | |
| alias | No | Result column name | concatenated |
| limit | No | Maximum number of rows to return | |
| table | No | Table name (Note: Pass a table name, not a raw string) | |
| where | No | Additional WHERE clause for filtering | |
| filter | No | Alias for where | |
| columns | No | Columns to concatenate (Note: Pass column names, not raw strings) | |
| separator | No | Separator between values | |
| tableName | No | Alias for table | |
| includeSourceColumns | No | Include individual source columns in output (default: false). Set to true for full context. |
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 |