且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

一列中是否有多个值?

更新时间:2022-01-23 22:16:02

您应该使用两个表,上面是原始表,另外一个表中每条类似的文章都有一行.

You should use two tables, the original one you have above, and a separate one that has one row per Article-Similar Article.

因此,您的原始表格将是:文章

So your original table would be: Articles

    ID     Content   
    1          bla 
    2          blah 
    3          etc.
    4          whatever

您的其他表格将与上面一样:ArticlesSimilar

And your other table would be as you have above: ArticlesSimilar

    ID     Similar_ID   
    3          1
    3          2
    4          1
    4          2
    4          3

您将确保ID-Similar_ID的组合为唯一.

You would ensure that the combination ID-Similar_ID were UNIQUE.