Are you allowed to use numbers as table names in MySQL?

by

Rules for naming objects, including tables in MySql:

http://dev.mysql.com/doc/refman/5.1/en/identifiers.html

Identifiers may begin with a digit but
unless quoted may not consist solely
of digits.

So this would be invalid:

 SELECT * FROM 12345;

But the following would be valid:

 SELECT * FROM `12345`;

Or if running in ANSI mode the following would work:

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

More Related Contents:

  1. multiple query same table but in different columns mysql
  2. How can I make SQL case sensitive string comparison on MySQL?
  3. Import data in MySQL from a CSV file using LOAD DATA INFILE
  4. How to do a batch insert in MySQL
  5. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  6. Get current AUTO_INCREMENT value for any table
  7. xampp MySQL does not start
  8. Insert auto increment primary key to existing table
  9. Connect to mysql on Amazon EC2 from a remote server
  10. Docker-compose check if mysql connection is ready
  11. SQL: selecting rows where column value changed from previous row
  12. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  13. How to generate data in MySQL?
  14. MySQL error 1241: Operand should contain 1 column(s)
  15. MySQL – Supertype/Subtype design
  16. Mysql: Order by like?
  17. How to use django models with foreign keys in different DBs?
  18. Can’t import database through phpmyadmin file size too large
  19. How to change MySQL column definition?
  20. How can I undo a mysql statement that I just executed?
  21. Continue SQL query even on errors in MySQL workbench
  22. How to generate a UUIDv4 in MySQL?
  23. MySQL : how to remove double or more spaces from a string?
  24. is php sort better than mysql “order by”?
  25. Mysql returning clause equivalent
  26. How can “set timestamp” be a slow query?
  27. Execute INSERT if table is empty?
  28. Mysql How do you create a clustered index?
  29. Counting associated entries with Sequelize
  30. MySQL data directory location

Leave a Comment