← Back to team overview

maria-discuss team 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>
> 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@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
>



-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle

References