Menu
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:\xampp\htdocs\erp_zaara\system\database\DB_driver.php Line Number: 330 Is there any way to solve this prob with the table name (temp_01-01-000001).
464
No, the hyphen is an operator, and you can't use that in the middle of an identifier.
MySQL Does not supports MINUS or EXCEPT ,You can use NOT EXISTS , NULL or NOT IN .
Since MySQL does not provide support for MINUS operator. However, we can use a LEFT JOIN clause to simulate this operator. We can use the following syntax to simulate the MINUS operator: SELECT column_list FROM table1.
Nope. Underscores are perfectly legal in table names.
You have to add quotes as your table name contains number. I think the following query will work.
SELECT * FROM `temp_01-01-000001` If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
