Re: mysql does not have table functions?

Interesting - glad to see it is still alive. Not of any help to me though. There's not likely to be a binary for IBM i and I'm not interested in compiling it myself. It was Oracle dropping IBM i support that forced Zend to come up with the ZendDb (their binary of MySQL) and subsequently to switch to MariaDB.

I'll stick with Db2, the older MySQL and MariaDB.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

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

excellent article on mySQL
https://modern-sql.com/blog/2018-04/mysql-8.0

author says the just released mySQL 8.0 is a solid database.


On Fri, May 4, 2018 at 2:04 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

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

www.partner400.com
www.SystemiDeveloper.com

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://www.youtube.com/watch?time_continue=2003&v=nFfS1HmiWCM

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

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