- Access to Resources 3305
- Active Advertising Systems 36
- Courses, Lessons 375
- Crypto industry 912
- Databases 1208
- Base of Trust sites 136
- Others 1072
- Design 1421
- Game Accounts 39147
- Gift Cards 1546
- Hosting 43
- Invites 83
- iTunes & App Store 1169
- Social Networks 3631
- Templates 105
- Miscellaneous 602
MySQL database with music 2023 (113 million songs)
Content: text 39 symbols
Product description
When purchasing a product, you will receive a link to download a 5.00 GB ZIP archive with SQL files (dump of MySQL database). Weight after unpacking: 39.9 GB.
Relevance of the database - August 2023
Each table and field is marked with comments so that you understand what is in this field.
There are 7 tables in the database. 4 main and 3 auxiliary.
Main:
- albums 14773454 (14.7 million) records - Albums (id, title (album name), releaseDate (release date), year (year), genre (genre))
- artists - 7954121 (7.9 million) entries - Artists (id, name (Artist name))
- labels - 2189594 (2.1 million) records - Labels (id, name (Label name))
- tracks - 113141050 (113.1 million) records - Songs (id, title (Title), duration (Duration in seconds), artists_name (Names of all artists added here for convenience, so you don´t have to drag them through links)
Auxiliary:
- album_label - Table for linking albums to labels to know which albums belong to which labels
- album_track - A table to link albums to songs so you know which song is from which album
- track_artist - A table for linking songs and artists to know which artists perform which song
Feedback
0| Period | |||
| 1 month | 3 months | 12 months | |
| 0 | 0 | 0 | |
| 0 | 0 | 0 | |