MySQL Forums
Forum List  »  Stored Procedures

Re: Procedure that select different number of columns
Posted by: Zawisza Czarny
Date: October 21, 2013 11:56PM

>> how about writing a query that returns to application env table?
>I don't understand that question.

For my app I need other stuff then just parameters and item id's ;) so this query should return also other stuff at once e. g.

item 1 name; number of items; when added; OTHER STAFF ; parameter 1 name; parameter val
item 1 name; number of items; when added; OTHER STAFF ; parameter 2 name; parameter val
item 1 name; number of items; when added; OTHER STAFF ; parameter 3 name; parameter val
item 2 name; number of items; when added; OTHER STAFF ; parameter 1 name; parameter val
...

This have a lot of unneeded data (repetition first x cols) but I don't need to make a pivot table, and I don't need to get rid of EAV table when doing something like this, and I have all needed data in single query.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Procedure that select different number of columns
1135
October 21, 2013 11:56PM


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.