1. Create a database named music-collection-db and table named: musiccollect. Your table should contain the following columns: Song Title, Composer, Singer, Album Name, Genre (Rock/Alternative, Electronic, Classical, Country, Pop, Jazz, Blues, Reggae/Dub/Ska, World, Punk, Metal, Ambient/Instrumental ), Label, Date Released, Total Length, Youtube Link, Where to Buy, and Price. Create 30 rows containing list of songs with varied genre. 2. Using your music-collectiondb, perform the following operation: - Make connection database - Insert 5 additional records - Fetch record using where and like clause - Update record using in and where clause - Delete 2 records - Sort records from table
1. Create a
Your table should contain the following columns: Song Title, Composer, Singer,
Album Name, Genre (Rock/Alternative, Electronic, Classical, Country, Pop, Jazz,
Blues, Reggae/Dub/Ska, World, Punk, Metal, Ambient/Instrumental ), Label, Date
Released, Total Length, Youtube Link, Where to Buy, and Price. Create 30 rows
containing list of songs with varied genre.
2. Using your music-collectiondb, perform the following operation:
- Make connection database
- Insert 5 additional records
- Fetch record using where and like clause
- Update record using in and where clause
- Delete 2 records
- Sort records from table
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images