Can a number be used to name a MySQL table column?

by

From the docs:

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

Which means you must quote it with back ticks like `25`:

UPDATE table SET `25`='100' WHERE id='1'

More Related Contents:

  1. add column to mysql table if it does not exist
  2. MySQL: ALTER TABLE if column not exists
  3. Adding multiple columns AFTER a specific column in MySQL
  4. Using ALTER to drop a column if it exists in MySQL
  5. SELECTING with multiple WHERE conditions on same column
  6. grant remote access of MySQL database from any IP address
  7. Should MySQL have its timezone set to UTC?
  8. JDBC batch insert performance
  9. SQL – Update multiple records in one query
  10. How to find gaps in sequential numbering in mysql?
  11. Can I create view with parameter in MySQL?
  12. MySQL: Invalid use of group function
  13. Exporting results of a Mysql query to excel?
  14. OUTPUT Clause in MySQL
  15. use mysql SUM() in a WHERE clause
  16. Sorting by date & time in descending order?
  17. passing LIMIT as parameters to MySQL sproc
  18. Case statement in MySQL
  19. MySQL: Inner join vs Where [duplicate]
  20. MySQL ‘UPDATE ON DUPLICATE KEY’ without a unique column?
  21. Selecting from two tables with inner join and limit [duplicate]
  22. Import MySQL dump to PostgreSQL database
  23. How to select data where a field has a min value in MySQL?
  24. Database corruption with MariaDB : Table doesn’t exist in engine
  25. How to SELECT by MAX(date)?
  26. MYSQL declaring variables
  27. get a recursive parent list
  28. MYSQL – Split Data Into Multiple Rows
  29. MySQL: Computed Column
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment