Re: mysql does not have table functions?

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.