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
mdcal...@gmail.com

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to