Re: mysql does not have table functions?

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

MySQL is not updated? Not true. Oracle provides regular updates to MySQL.
The most recent being mySQL 8.0 released last month. And the documentation
for mySQL is quite good. Last I looked, the documentation for Maria was
poor, and as time goes by, the differences between Maria and mySQL
increase, so the mySQL documentation is not so good for Maria.

On Fri, May 4, 2018 at 11:21 AM, Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

> If you are asking if you can get a list of tables in a database, list of
> databases, or the schema of the tables inside a database, yes you can get
> all of that from MySQL.  Remember MySQL is now longer updated by anyone.  I
> think Maria might be the better option.   15 minutes inside the
> documentation will show you.
>
> What databases are there:  "show databases"
> What is the schema:  "show schema"
> What tables are in the database:  "use database", then "show tables"
>
> https://dev.mysql.com/doc/refman/8.0/en/show-databases.html
>
> As to Maria having more features than DB2, not ever going to happen.  Maria
> is a fine database and does an excellent job, but comparing it to DB2 which
> is an Enterprise Class full service database is a bit like comparing a Yugo
> car to a Lincoln Navigator.  Two different classes of database/car.
>
>
> --
> Jim Oberholtzer
> Agile Technology Architects
>
>
> -----Original Message-----
> From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Steve
> Richter
> Sent: Friday, May 04, 2018 9:57 AM
> To: Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
> 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.
>
>
> --
> 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.