MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: A Table Manipulation question. I'm stuck
Posted by: Peter Brawley
Date: October 15, 2015 10:10PM

>need to transpose the data such that the second table has one row for all the items in table1 for a given date.

That's a pivot table, for several methods see that topic at http://www.artfulsoftware.com/infotree/queries.php

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


Subject
Written By
Posted
A Table Manipulation question. I'm stuck
Paul Zorsky
October 14, 2015 10:24PM
Re: A Table Manipulation question. I'm stuck
Peter Brawley
October 15, 2015 11:14AM
Re: A Table Manipulation question. I'm stuck
Paul Zorsky
October 15, 2015 05:23PM
Re: A Table Manipulation question. I'm stuck
Peter Brawley
October 15, 2015 10:10PM


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.