我想备份我的数据库时出现错误
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
有没有办法用表名(temp_01-01-000001)解决这个问题。
发布于 2013-09-07 14:46:40
您可以编辑文件/system/database/drivers/mysql/mysql_utility.php的第132行
发自:
$query = $this->db->query("SELECT * FROM $table");
至:
$query = $this->db->query("SELECT * FROM `$table`");
发布于 2013-09-07 14:21:12
您必须添加引号,因为您的表名包含number。我认为下面的查询会起作用。
SELECT * FROM `temp_01-01-000001`
https://stackoverflow.com/questions/18670394
复制相似问题