mysql - 多对多关系mysql设计

Question

关闭。此题需要 details or clarity 。目前不接受答案。

---

想要改进这个问题吗？通过 editing this post 添加详细信息并澄清问题.

已关闭 3 年前。

Improve this question

许多用户可以有很多选项卡，所以我设计了这个表格

user
uId (PK)



user-tab
uId (FK)
tabId (FK)



tab
tabId (PK)

但是当我尝试添加FK时在user-tab我收到这个错误

1050 - Table '.\db\tab@002duser' already exists 

Answer 1

这不是您的数据库设计或现有记录的问题，而是命名问题。

MySQL 命名不带引号的标识符的规则是 snake_case_writing 而不是 CamelCase 或 dash-style-writing，使用

来自Docs :

Permitted characters in unquoted identifiers (not strings, values):

ASCII: [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore)

Extended: U+0080 .. U+FFFF

编辑

文档的另一个节选(此内容以及更多内容需要阅读 here )

Naming Conventions For identifiers formed from multiple words,separate each component with underscore rather than capitalization.Thus, use my_var instead of myVar or MyVar.

Avoid capitalization except for class names; class names should beginwith a capital letter.

class Item; class Query_arena; class Log_event; Avoid function names,structure elements, or variables that begin or end with '_'.

Use long function and variable names in English. This will make yourcode easier to read for all developers.