maria-discuss team mailing list archive
Mailing list archive
Re: How to get child data from a dynamic column
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@xxxxxxxxxxx>:
> 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@xxxxxxxxx>
> > 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@xxxxxxxxxxxxxxxx.
> > 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
Eng. Automação e Controle