Re: mysql does not have table functions?

Yes I realize it has been possible to do for some time Tim, but SQL syntax can be arcane at the best of times and frankly I tend to be more interested in readability than performance - at least until performance become an issue!


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 6, 2018, at 3:49 PM, Tim Fathers <X700-IX2J@xxxxxxxxxxx> wrote:

In fact for web apps it had features such as result set offset capability that only just came to DB2.

You could always do this using the OLAP row_number() function and then selecting to and from the generated row. This sounds like it would be very slow but it's in fact very fast. When the offset and limit functionality came I was keen to simplify our paged SQLs with it but I found it performed considerably worse than the row_number() way, so in my experience, it's not a good way to select pages of data for web apps. I haven't tried it again recently, so it might have been optimised since.

Tim
________________________________
From: WEB400 <web400-bounces@xxxxxxxxxxxx> on behalf of Jon Paris <jon.paris@xxxxxxxxxxxxxx>
Sent: 04 May 2018 20:04
To: Web400@Midrange. Web400
Subject: Re: [WEB400] mysql does not have table functions?

Until Oracle bought it, MySQL was, while not bleeding edge, a very capable database. In fact for web apps it had features such as result set offset capability that only just came to DB2. But for Oracle if it was further enhanced it was just a threat to their main product. Hardly surprising that it now lags in features. Maria, once it got up and running from the ashes, has started to move it forward again but it will take time.


Jon Paris

https://eur01.safelinks.protection.outlook.com/?url=www.partner400.com&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=GV2CXyO%2BXxdObD2CNa001sOre2aCRNvH4hwLHJ0auQU%3D&reserved=0
https://eur01.safelinks.protection.outlook.com/?url=www.SystemiDeveloper.com&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=p77FC8rW7HDNWqZ4ipkF6dmypXeaZc8AB2D%2BqN%2BEFh0%3D&reserved=0

On May 4, 2018, at 1:50 PM, Steve Richter <stephenrichter@xxxxxxxxx> wrote:

hi Richard,

the use case is that since I am writing all my IBM i apps now with SQL and
PHP on the server side and javascript in the browser, what is the
feasibility of porting that server code to a web hosting site that runs PHP
and mySQL.

but watch this video
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Ftime_continue%3D2003%26v%3DnFfS1HmiWCM&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=tJCjvBoRAFVyshqcWYyi%2FFuckUrEEMtltjXk7XM84C4%3D&reserved=0

mySQL does not support much at all.



On Fri, May 4, 2018 at 1:03 PM, Richard Schoen <
Richard.Schoen@xxxxxxxxxxxxxxx> wrote:

Out of curiosity can you describe your use case ?

Normally I run SQL or SProcs and they return a data set which my app can
consume.

Are you wanting to output to a new table in the DB or something else ?

Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

----------------------------------------------------------------------

message: 1
date: Fri, 4 May 2018 10:57:18 -0400
from: Steve Richter <stephenrichter@xxxxxxxxx>
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://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=S1I7wQywjqRyh2ziF9n96VmWf7ofivW235t%2F%2FuPOJa0%3D&reserved=0
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=LNRmDfHTRTasTd8oZoCrMtD0QTniXvEQGk0hpMrRwqA%3D&reserved=0.

--
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://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=S1I7wQywjqRyh2ziF9n96VmWf7ofivW235t%2F%2FuPOJa0%3D&reserved=0
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=LNRmDfHTRTasTd8oZoCrMtD0QTniXvEQGk0hpMrRwqA%3D&reserved=0.

--
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://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fweb400&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=S1I7wQywjqRyh2ziF9n96VmWf7ofivW235t%2F%2FuPOJa0%3D&reserved=0
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fweb400&data=02%7C01%7C%7C099489c17bf84cc42aac08d5b1e98aaf%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636610538962009917&sdata=LNRmDfHTRTasTd8oZoCrMtD0QTniXvEQGk0hpMrRwqA%3D&reserved=0.

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