MySQL是否允许使用点创建数据库?

2021-11-20 00:00:00 database naming-conventions mysql

MySQL 是否允许创建名称中带有点 (.) 的数据库?

Does MySQL allows to create database which has dot (.) in its name?

我使用的是 MySQL 5.1.22.

I'm using MySQL 5.1.22.

推荐答案

不能在数据库名称中使用点.另外，我会避免在任何标识符中使用它.一个常见的约定是使用下划线代替.它将用于相同的目的，并会避免很多混淆.如果您确实有充分的理由在表或字段名称中使用奇怪的或非法的字符，那么您必须将其转义.

You can't use the dot in a database name. Also, I'd avoid using it in any identifier. A common convention is to use underscore instead. It will serve the same purpose and will avoid a LOT of confusion. If you do have a good reason for using strange and otherwise-illegal characters in a table or field name, then you have to escape it.

要在 MySQL 中转义标识符，请使用反引号:

to escape identifiers in MySQL, use the backtick:

SELECT `select`, `some.field name`, `crazy()naming+here` FROM `my-=+table`

在我看来，无论您是否需要，养成对所有字段名称都加反引号的习惯是一个很好的做法，但那是另一回事了.

Getting into the habit of backticking all field names regardless of whether you need to is a good practice in my opinion, but that's another story.

相关文章