× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



The stackexchange post includes a link to the mySQL docs...

The current 8.0 version still doesn't support UDTF.

Guess they don't feel they need it.

UDTF was added to the SQL:2003 standards...
http://comet.lehman.cuny.edu/jung/cmp420758/SQL2003Paper.pdf

Charles

On Fri, May 4, 2018 at 9:48 AM, Steve Richter <stephenrichter@xxxxxxxxx>
wrote:

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-to-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_systems


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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.