Can MySQL Table Names Be Just Numbers?

Table Naming in MySQL: Can Numbers Be Used?

It is often necessary to dynamically create new tables in MySQL. A question that arises is whether it is permissible to use tables named solely with numbers.

Rules for Table Naming in MySQL

According to MySQL documentation, identifiers like table names have specific naming rules:

• Identifiers can start with a digit.
• However, they cannot consist entirely of digits unless they are quoted.

Implications for Using Numbers as Table Names

These rules imply the following:

• Invalid: SELECT * FROM 12345; (table name is not quoted)
• Valid: SELECT * FROM 12345; (table name is quoted)

ANSI Mode Alternative

In ANSI mode, the following syntax is also valid for unquoted number-only table names:

• SET @@session.sql_mode=ANSI_QUOTES;
• SELECT * FROM "12345";

Conclusion

As long as proper quoting is used or ANSI mode is enabled, it is permissible to have number-only table names in MySQL, providing flexibility for dynamic table creation.

The above is the detailed content of Can MySQL Table Names Be Just Numbers?. For more information, please follow other related articles on the PHP Chinese website!