Can You Create MySQL Databases with Dots in Their Names?

Creating Databases with Dots in MySQL

MySQL users may encounter a common question: can databases be created with dots (.) in their names? This article delves into this topic, offering a comprehensive answer and providing practical solutions.

Issue:

Does MySQL allow for the creation of databases containing dots in their names? This question is particularly relevant for MySQL version 5.1.22.

Answer:

The answer is no, MySQL does not allow the creation of databases with dots. Additionally, it is advisable to avoid using dots in any identifier, instead opting for underscores as a substitute. This convention promotes clarity and avoids confusion.

However, if there is a compelling reason to use special characters in a table or field name, MySQL provides an escape mechanism. Identifiers can be escaped using backticks (`) as demonstrated below:

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

As a best practice, it is recommended to consistently backtick field names regardless of necessity. Doing so ensures consistency and clarity in your database schema.

The above is the detailed content of Can You Create MySQL Databases with Dots in Their Names?. For more information, please follow other related articles on the PHP Chinese website!