MySQL Forums
Forum List  »  Stored Procedures

Re: Procedure that select different number of columns
Posted by: Rick James
Date: October 22, 2013 09:19AM

UNIQUE KEY `itemID_UNIQUE` (`itemID`),
A PRIMARY KEY is a UNIQUE KEY, so DROP itemID_UNIQUE. (Ditto in most of the other tables.)

Would you accept this output?
name       | symbol      | number | Attributes                                              |
resistor   | SMD0805100K | 321    | resistance=100k, power=1/4                              | 
stabilizer | LM7805      | 2      | input voltage=7.5-35, output voltage=5, max current=1A5 |
That could be done with a combination of a subquery, CONCAT(), CONCAT_WS(), etc. Make a crack at it; I'll help you out if you get in trouble.

Options: ReplyQuote

Written By
Re: Procedure that select different number of columns
October 22, 2013 09:19AM

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.