Re: mysql does not have table functions?

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.