Row Value

A Row Value is an ordered list of values.

row_value
  : (value [, value...])
  | (select_query)
  | JSON_ROW(json_query, json_data)

value

value

select_query

Select Query

Retrieved fields of select_query are used as listed values. The result set of select_query must have at most one record.

json_query

JSON Query

Empty string is equivalent to “[]”.

json_data

string

Row Values can be used in limited operation such as Comparison Operation or Insert Query. In most cases, a row value with a single value is interpreted as a value with parentheses.