using (-) dash in mysql table name

Question

There is an error while i want to backup my database

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-01-000001' at line 1

SELECT * FROM temp_01-01-000001

Filename: F:xampphtdocserp_zaarasystemdatabaseDB_driver.php

Line Number: 330

Is there any way to solve this prob with the table name (temp_01-01-000001).

Answer 1

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

SELECT * FROM `temp_01-01-000001`