Re: [Maria-discuss] How to get child data from a dynamic column
Re-directing from the MariaDB Manager mailing list to maria-discuss where MariaDB Server discussions happen! On 9 Jun 2014, at 22:26, Newton Bastardo López <newromarco@gmail.com> wrote:
I have a dynamic column with the next extructure:
blob_fields: name1: value1, name2: value2, name3: sub-name1: sub-value1, sub-name2: sub-value2
With COLUMN_GET(), how can I get those values childdren of 'name3'?
I was thinking use COLUMN_GET(blob_fields, COLUMN_GET(name3, sub-name1 as char)) as value, but It doenst work for me...
Thanks to much!
-- You received this message because you are subscribed to the Google Groups "MariaDB-Manager" group. To unsubscribe from this group and stop receiving emails from it, send an email to mariadbmanager+unsubscribe@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
-- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles
get the name3 column value, and after get the sub name value COLUMN_GET(COLUMN_GET(blob_fields, name3 as blob),sub-name1 AS char) must check if should be use as blob at name3 2014-06-15 4:53 GMT-03:00 Colin Charles <colin@mariadb.org>:
Re-directing from the MariaDB Manager mailing list to maria-discuss where MariaDB Server discussions happen!
On 9 Jun 2014, at 22:26, Newton Bastardo López <newromarco@gmail.com> wrote:
I have a dynamic column with the next extructure:
blob_fields: name1: value1, name2: value2, name3: sub-name1: sub-value1, sub-name2: sub-value2
With COLUMN_GET(), how can I get those values childdren of 'name3'?
I was thinking use COLUMN_GET(blob_fields, COLUMN_GET(name3, sub-name1 as char)) as value, but It doenst work for me...
Thanks to much!
-- You received this message because you are subscribed to the Google Groups "MariaDB-Manager" group. To unsubscribe from this group and stop receiving emails from it, send an email to mariadbmanager+unsubscribe@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
-- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles
_______________________________________________ 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
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
participants (2)
-
Colin Charles
-
Roberto Spadim