Create a query/queries to read from the sakila database the following informatio

Question

Create a query/queries to read from the sakila database the following information: film title, and actors in each film. Write to a file called FilmActors. txt the information from step 1 in the following format That is to say, each record in the file will start with the film title, followed by a colon and then the number of actors in that movie. Finally, you will list the actors' last name, then first name, with each actor's name separated by a semi-colon. Sort by Film Title. You may use any combination of SQL/PHP you wish. You can write a fancy SQL statement to do some processing for you, or you can simply use SQL to "grab" the info from the database, then use PHP to process the info.

Explanation / Answer

1. SELECT film_title, actors FROM FILMS;

2. SELECT film_title, actors FROM FILMS; OUTPUT TO FilmActors.txt FORMAT TEXT;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.