📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

MAP_CAT



Returns the concatenatation of two MAPs.

Syntax

MAP_CAT( <map1>, <map2> )

Arguments

ArgumentsDescription
<map1>The source MAP.
<map2>The MAP to be appended to map1.

Return Type

Map.

Examples

SELECT MAP_CAT({'a':1,'b':2,'c':3}, {'c':5,'d':6}); ┌─────────────────────────────────────────────┐ │ map_cat({'a':1,'b':2,'c':3}, {'c':5,'d':6}) │ ├─────────────────────────────────────────────┤ │ {'a':1,'b':2,'c':5,'d':6} │ └─────────────────────────────────────────────┘

Was this page helpful?