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.
midrange.com
