Re: mysql does not have table functions?

[Steve Richter <stephenrichter@xxxxxxxxx>]

mariaDB looks interesting with connect to JSON data files and JSON user
defined functions

https://mariadb.com/kb/en/library/connect-json-table-type/

On Fri, May 4, 2018 at 1:50 PM, Steve Richter <stephenrichter@xxxxxxxxx>
wrote:

> hi Richard,
>
> the use case is that since I am writing all my IBM i apps now with SQL and
> PHP on the server side and javascript in the browser, what is the
> feasibility of porting that server code to a web hosting site that runs PHP
> and mySQL.
>
> but watch this video
> https://www.youtube.com/watch?time_continue=2003&v=nFfS1HmiWCM
>
> mySQL does not support much at all.
>
>
>
> On Fri, May 4, 2018 at 1:03 PM, Richard Schoen <
> Richard.Schoen@xxxxxxxxxxxxxxx> wrote:
>
> > Out of curiosity can you describe your use case ?
> >
> > Normally I run SQL or SProcs and they return a data set which my app can
> > consume.
> >
> > Are you wanting to output to a new table in the DB or something else ?
> >
> > Regards,
> > Richard Schoen
> > Director of Document Management
> > e. richard.schoen@xxxxxxxxxxxxxxx
> > p. 952.486.6802
> > w. helpsystems.com
> >
> > ----------------------------------------------------------------------
> >
> > message: 1
> > date: Fri, 4 May 2018 10:57:18 -0400
> > from: Steve Richter <stephenrichter@xxxxxxxxx>
> > subject: [WEB400] mysql does not have table functions?
> >
> > is that true, mySQL does not support functions that return tables?  Was
> > expecting mySQL to have more features than DB2, not less.
> >
> >
> >
> > --
> > This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
> > list
> > To post a message email: WEB400@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/web400
> > or email: WEB400-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/web400.