MySQL Forums
Forum List  »  PHP

Re: Query divides movie titles into different columns
Posted by: Peter Brawley
Date: November 14, 2019 07:27PM

You're flailing, slow down, take a breath.

The query you just posted has multiple problems.

We build complex queries, based on a statement of requirement, from simpler components. The query you posted just before that one ...

select actor_id, group_concat(distinct film_id order by film_id asc separator ' ')
from film_actor
group by actor_id;

... looks like a good start, but we're missing a fundamental step---a statement of the query requirement. It's as foolhardy to try to write a complex query without a detailed statement of the requirement as it would be to build a house without an architectural plan.

So let's see a complete statement of the requirement.

Options: ReplyQuote

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.