- Access to Resources 3130
- Active Advertising Systems 36
- Courses, Lessons 386
- Crypto industry 612
- Databases 1189
- Base of Trust sites 136
- Others 1053
- Design 1409
- Game Accounts 36280
- Gift Cards 1653
- Hosting 41
- Invites 266
- iTunes & App Store 1240
- Social Networks 3949
- Templates 103
- Miscellaneous 584
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 | |