MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Complicated Query
Posted by: Peter Brawley
Date: June 06, 2013 08:29PM

It's an EAV schema, so it's a nightmare to write even simple queries for it. Consider abandoning EAV for a straightforward design. If you insist on an EAV design, see "Pivot table basics: rows to columns" at http://www.artfulsoftware.com/queries.php.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Complicated Query
Rodrigo Lopes
June 06, 2013 07:44PM
Re: Complicated Query
Peter Brawley
June 06, 2013 08:29PM
Re: Complicated Query
Keith Larson
June 06, 2013 08:55PM
Re: Complicated Query
Raghuram Venkatesan
June 07, 2013 01:01AM
Re: Complicated Query
Keith Larson
June 07, 2013 06:02AM
Re: Complicated Query
Raghuram Venkatesan
June 07, 2013 12:18PM
Re: Complicated Query
Keith Larson
June 07, 2013 03:12PM
Re: Complicated Query
Rick James
June 08, 2013 06:01AM
Re: Complicated Query
Keith Larson
June 08, 2013 09:47AM


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.