问题描述
我需要帮助在 MySQL 中为音乐数据库构建表.我不确定如何将这些信息放在表格中.
I need some help building a table(s) for a music database in MySQL. I am unsure on how to lay this information out in a table.
这是我想存储在数据库中的信息.
Here is the info I would like to be stored in the database.
基本上任何与组织数字音乐有关的事情.我是数据库的新手,我有一些想法.但如果我要学习,我不妨学习正确的做法.
Basically anything that has to do with organizing digital music. I'm new to databases and I have some ideas. But if I'm going to learn I might as well learn the right way of doing it.
任何关于如何设计我的桌子的想法都会很棒.
Any thoughts on how to design my table(s) would be awesome.
推荐答案
这样的事情最好开始.它为艺术家、专辑(包含艺术家和流派的关键字)、曲目(包含专辑的关键字)和流派指定了一个表格.
Something like this would be good to start with. It specifies a table for artists, albums (with keys into artists and genres), tracks (keyed into albums), and genres.
这篇关于音乐库 MySQL 数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!