← Back to team overview

maria-discuss team mailing list archive

getting all name-value pairs from a dynamic column


These docs are excellent -- http://kb.askmonty.org/en/dynamic-columns

How do you fetch all name-value pairs from a dynamic column in a
format that can be consumed by a client? The client can select the
column as is but then must know how mariadb encoded it. The function
column_list returns the column names. If there were a function that
encoded all name-value pairs as JSON, then the client could do
something like this and be able to decode the result:
  select column_json(dynamic_column_name) from t where ...

Mark Callaghan

Follow ups