在mysql表名中使用(-)破折号 [英] using (-) dash in mysql table name

问题描述

我要备份数据库时出现错误

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

有什么办法可以用表名(temp_01-01-000001)解决这个问题.

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

推荐答案

您可以编辑文件/system/database/drivers/mysql/mysql_utility.php

You could edit line 132 of the file /system/database/drivers/mysql/mysql_utility.php

发件人:

$query = $this->db->query("SELECT * FROM $table");

收件人:

$query = $this->db->query("SELECT * FROM `$table`");

这篇关于在mysql表名中使用(-)破折号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！