using (-) dash in mysql table name

by

You have to add quotes as your table name contains number. I think the following query will work.

SELECT * FROM `temp_01-01-000001`

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. How do I specify unique constraint for multiple columns in MySQL?
  3. Select all columns except one in MySQL?
  4. MYSQL OR vs IN performance
  5. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  6. MySQL Conditional Insert
  7. How to properly create composite primary keys – MYSQL
  8. Is there a MySQL option/feature to track history of changes to records?
  9. MySQL JOIN ON vs USING?
  10. MySQL: multiple tables or one table with many columns? [closed]
  11. How can I Insert many rows into a MySQL table and return the new IDs?
  12. How to store IPv6-compatible address in a relational database
  13. MySQL: View with Subquery in the FROM Clause Limitation
  14. MySql export schema without data
  15. What is cardinality in MySQL?
  16. How to prepend a string to a column value in MySQL?
  17. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  18. Using ORDER BY and GROUP BY together
  19. How can VBA connect to MySQL database in Excel?
  20. MySQL Pivot Table Column Data as Rows
  21. updating columns with a sequence number mysql
  22. How repair corrupt xampp ‘mysql.user’ table?
  23. Select a column with a keyword name
  24. How to only select numeric data from mysql?
  25. What is the MySQL query equivalent of PHP strip_tags?
  26. Select all months within given date span, including the ones with 0 values
  27. Use Composite Primary Key as Foreign Key
  28. List of Constraints from MySQL Database
  29. MySQL Recursive get all child from parent
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment