php - MySQL 从 database.table 中选择记录(数据库名称包含 '-' )

Question

我想从另一个数据库中获取行，所以我创建了查询:

SELECT * FROM database-test.users

MySQL 结果错误:

Database_Exception [ 42000 ]: SQLSTATE[42000]: Syntax error or access violation: 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 '-test.users' at line 1

如何解决？

谢谢回复

Answer 1

你需要像下面那样做(在表名周围使用反引号):-

SELECT * FROM `database-test`.users

或者

SELECT * FROM `database-test`.`users`