• <tfoot id='BLGDe'></tfoot>
  • <legend id='BLGDe'><style id='BLGDe'><dir id='BLGDe'><q id='BLGDe'></q></dir></style></legend>
    <i id='BLGDe'><tr id='BLGDe'><dt id='BLGDe'><q id='BLGDe'><span id='BLGDe'><b id='BLGDe'><form id='BLGDe'><ins id='BLGDe'></ins><ul id='BLGDe'></ul><sub id='BLGDe'></sub></form><legend id='BLGDe'></legend><bdo id='BLGDe'><pre id='BLGDe'><center id='BLGDe'></center></pre></bdo></b><th id='BLGDe'></th></span></q></dt></tr></i><div id='BLGDe'><tfoot id='BLGDe'></tfoot><dl id='BLGDe'><fieldset id='BLGDe'></fieldset></dl></div>

    <small id='BLGDe'></small><noframes id='BLGDe'>

          <bdo id='BLGDe'></bdo><ul id='BLGDe'></ul>

        音乐库 MySQL 数据库

        时间:2024-04-16

          <tfoot id='dDJ57'></tfoot>

          <small id='dDJ57'></small><noframes id='dDJ57'>

              <tbody id='dDJ57'></tbody>

              <legend id='dDJ57'><style id='dDJ57'><dir id='dDJ57'><q id='dDJ57'></q></dir></style></legend>
                <i id='dDJ57'><tr id='dDJ57'><dt id='dDJ57'><q id='dDJ57'><span id='dDJ57'><b id='dDJ57'><form id='dDJ57'><ins id='dDJ57'></ins><ul id='dDJ57'></ul><sub id='dDJ57'></sub></form><legend id='dDJ57'></legend><bdo id='dDJ57'><pre id='dDJ57'><center id='dDJ57'></center></pre></bdo></b><th id='dDJ57'></th></span></q></dt></tr></i><div id='dDJ57'><tfoot id='dDJ57'></tfoot><dl id='dDJ57'><fieldset id='dDJ57'></fieldset></dl></div>
                  <bdo id='dDJ57'></bdo><ul id='dDJ57'></ul>

                • 本文介绍了音乐库 MySQL 数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我需要帮助在 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.

                  Artist Name
                  Album Name
                  Release Date
                  Genre
                  Picture URL (album artwork)
                  
                  Track Number
                  Trank Name
                  Track Playtime
                  Lyric (optional, But would like to have it someday)
                  
                  etc.
                  

                  基本上任何与组织数字音乐有关的事情.我是数据库的新手,我有一些想法.但如果我要学习,我不妨学习正确的做法.

                  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.

                  Table artists
                  ----
                  id (primary key),
                  name
                  description
                  years_active
                  otherinfo (whatever you need)
                  
                  Table albums
                  ----
                  id (primary key)
                  artistid (foreign key to artists table)
                  name,
                  releasedate
                  genreid (foreign key to genres table)
                  picture
                  
                  Table tracks
                  ----
                  id (primary key)
                  albumid (foreign key to albums table)
                  name
                  override_artist (overrides album artist if not null)
                  playtime
                  lyric
                  otherstuff as needed
                  
                  Table genres
                  ----
                  id (primary key)
                  name
                  description
                  

                  这篇关于音乐库 MySQL 数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:在 SQL Server 中设计 1:1 和 1:m 关系 下一篇:定义外键有什么好处

                  相关文章

                  <i id='AQHoM'><tr id='AQHoM'><dt id='AQHoM'><q id='AQHoM'><span id='AQHoM'><b id='AQHoM'><form id='AQHoM'><ins id='AQHoM'></ins><ul id='AQHoM'></ul><sub id='AQHoM'></sub></form><legend id='AQHoM'></legend><bdo id='AQHoM'><pre id='AQHoM'><center id='AQHoM'></center></pre></bdo></b><th id='AQHoM'></th></span></q></dt></tr></i><div id='AQHoM'><tfoot id='AQHoM'></tfoot><dl id='AQHoM'><fieldset id='AQHoM'></fieldset></dl></div>

                  <tfoot id='AQHoM'></tfoot>

                      <bdo id='AQHoM'></bdo><ul id='AQHoM'></ul>

                      <legend id='AQHoM'><style id='AQHoM'><dir id='AQHoM'><q id='AQHoM'></q></dir></style></legend>

                    1. <small id='AQHoM'></small><noframes id='AQHoM'>