Re: Query divides movie titles into different columns
If you want a new column for each instance of a key, you'll need to run a first query for such counts, compute how many columns are needed, then in a stored procedure, or a PHP function, programmatically generate the desired query.
And it'd be an odd query to read.
Better perhaps to use Group_Concat(), which was developed in MySQL for just such instances.
Edited 1 time(s). Last edit at 11/14/2019 02:22PM by Peter Brawley.
Subject
Written By
Posted
November 13, 2019 11:58PM
Re: Query divides movie titles into different columns
November 14, 2019 02:21PM
November 14, 2019 02:47PM
November 14, 2019 04:29PM
November 14, 2019 04:35PM
November 14, 2019 05:01PM
November 14, 2019 05:14PM
November 14, 2019 06:25PM
November 14, 2019 07:27PM
November 15, 2019 10:03AM
November 16, 2019 03:11AM
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.