Re: mysql does not have table functions?

I see nothing in any of these posts that cannot be done in SQL in DB2. I
personally don't have sufficient knowledge of SQL to do it, but I guarantee
there are others on this list that can.


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Steve Richter
Sent: Friday, May 04, 2018 10:49 AM
To: Web Enabling the IBM i (AS/400 and iSeries) <web400@xxxxxxxxxxxx>
Subject: Re: [WEB400] mysql does not have table functions?

no, I mean table functions. as asked in this question:
https://stackoverflow.com/questions/23421771/how-to-return-table-from-mysql-
function

DB2 has table functions. SQL SERVER also:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/how-t
o-use-table-valued-user-defined-functions

I checked maria DB and it does not appear to have them either.

here are some comparison charts. But does not mention table functions.
https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_s
ystems


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.

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