Homework Help is Here – Start Your Trial Now!
Engineering
Cybersecurity
USE MY SQL  List all the data in your table movie_prod, sorted by the id of the movie (smallest first)

USE MY SQL  List all the data in your table movie_prod, sorted by the id of the movie (smallest first)

icon
Related questions
Question

USE MY SQL 

List all the data in your table movie_prod, sorted by the id of the movie (smallest first)

mysql> select * from movie_prod; movie_id | prod_id | 2 1 NAFANMI MOTO 11 4 mrte 16 12 28 13 5 3 6 7 8 9 10 14 17 -оол ся сл сл сл сл сл на со со солонн 1 2 2 3 4 5 5 5 5 5 5 5 6 19 18 18 rows in set (0.00 sec) 6 7 mysql> DESC MOVIE; Field | Туре id title year duration gross rating prod_id int 7 rows in set (0.17 sec) mysql> DESC PRODUCTION; | Field Type int varchar(80) int int decimal (6, 1) decimal (3, 1) int varchar (30) id name 2 rows in set (0.00 sec) | Null | Key | Default | Extra NO PRI NULL NO NULL NULL NULL NULL YES YES YES NO 10.0 YES MUL NULL auto_increment | Null | Key | Default | Extra NO YES PRI NULL NULL auto_increment
Transcribed Image Text:mysql> select * from movie_prod; movie_id | prod_id | 2 1 NAFANMI MOTO 11 4 mrte 16 12 28 13 5 3 6 7 8 9 10 14 17 -оол ся сл сл сл сл сл на со со солонн 1 2 2 3 4 5 5 5 5 5 5 5 6 19 18 18 rows in set (0.00 sec) 6 7 mysql> DESC MOVIE; Field | Туре id title year duration gross rating prod_id int 7 rows in set (0.17 sec) mysql> DESC PRODUCTION; | Field Type int varchar(80) int int decimal (6, 1) decimal (3, 1) int varchar (30) id name 2 rows in set (0.00 sec) | Null | Key | Default | Extra NO PRI NULL NO NULL NULL NULL NULL YES YES YES NO 10.0 YES MUL NULL auto_increment | Null | Key | Default | Extra NO YES PRI NULL NULL auto_increment
mysql> select * from movie; id title 12345678901234671819 ANSFF OF Abominable Hotel Transylvania Onward Sing The SpongeBob Movie 2 Toy Story Toy Story 2 Toy Story 3 Toy Story 4 Soul Surf's Up Trolls Trolls World Tour Zootopia 6 Howl's Moving Castle Happy Feet Two 18 rows in set (0.01 sec) Happy Feet Cars 1 Columbia Pictures Dentsu mysql> select * from production; id name 3 DreamWorks 4 Paramount 5 Walt Disney Pictures Warner Bros 7 Pixar 7 rows in set (0.00 sec) year 2019 2012 2020 2016 2020 1995 1999 2010 2019 2020 2007 2016 2020 2016 2004 2006 2006 2011 duration 100 85 92 97 91 102 108 91 81 92 103 1066.9 100 1073.4 90 108 119 gross 108 117 100 179. 1 358. 3 142.0 634. 2 NULL 373.6 497.3 NULL 152.0 346.9 NULL 1023.8 236. 2 384. 3 462.0 159. 1 rating 5.0 9.0 8.3 8.3 8.7 7.9 9.0 8.3 9.5 4.7 5.0 9.0 8.7 8.3 8.2 6.4 10.0 10.0 prod_id 3 оноос со сонот спотот олнооноо 6
Transcribed Image Text:mysql> select * from movie; id title 12345678901234671819 ANSFF OF Abominable Hotel Transylvania Onward Sing The SpongeBob Movie 2 Toy Story Toy Story 2 Toy Story 3 Toy Story 4 Soul Surf's Up Trolls Trolls World Tour Zootopia 6 Howl's Moving Castle Happy Feet Two 18 rows in set (0.01 sec) Happy Feet Cars 1 Columbia Pictures Dentsu mysql> select * from production; id name 3 DreamWorks 4 Paramount 5 Walt Disney Pictures Warner Bros 7 Pixar 7 rows in set (0.00 sec) year 2019 2012 2020 2016 2020 1995 1999 2010 2019 2020 2007 2016 2020 2016 2004 2006 2006 2011 duration 100 85 92 97 91 102 108 91 81 92 103 1066.9 100 1073.4 90 108 119 gross 108 117 100 179. 1 358. 3 142.0 634. 2 NULL 373.6 497.3 NULL 152.0 346.9 NULL 1023.8 236. 2 384. 3 462.0 159. 1 rating 5.0 9.0 8.3 8.3 8.7 7.9 9.0 8.3 9.5 4.7 5.0 9.0 8.7 8.3 8.2 6.4 10.0 10.0 prod_id 3 оноос со сонот спотот олнооноо 6
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS