MySQL Forums
Forum List  »  Stored Procedures

Re: Procedure that select different number of columns
Posted by: Rick James
Date: October 20, 2013 04:09PM

> "Dynamic columns" in mariaDB did someone of you use it? Can I do something similar in mysql?

MariaDB is a compatible 'replacement' for MySQL. Dynamic Columns is one of several added features you get on top of standard MySQL.

> item count in each group will newer extend beyond even 300, so problems with performance are not expected

If you fetch only 300 rows, almost any solution (brute force or otherwise) will have "good enough" performance. So, it might be best to focus on simplicity of the implementation, not on performance.

Options: ReplyQuote

Written By
Re: Procedure that select different number of columns
October 20, 2013 04:09PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.