MySQL中用select语句分类统计中以中文为条件查询时报错的问题

Question

问题遇到的现象和发生背景

MySQL中用select语句分类统计中以中文为条件查询时报错的问题

问题相关代码，请勿粘贴截图

主表

SQL Query

SELECT
( SELECT COUNT(*) FROM `book` WHERE `book`.`publisher` = "文艺出版社") AS `文艺出版社`,

( SELECT COUNT(*) FROM `book` WHERE `book`.`publisher` = "人民邮电出版社" ) AS `人民邮电出版社`

( SELECT COUNT(*) FROM `book` WHERE `book`.`publisher` = "机械工业出版社" ) AS `机械工业出版社`

( SELECT COUNT(*) FROM `book` WHERE `book`.`publisher` = "清华大学出版社" ) AS `清华大学出版社`

( SELECT COUNT(*) FROM `book` WHERE `book`.`publisher` = "电子工业出版社" ) AS `电子工业出版社`

运行结果及报错内容

SQL Query

SELECT
( SELECT COUNT(*) FROM book WHERE book.publisher = "文艺出版社") AS 文艺出版社,

( SELECT COUNT(*) FROM book WHERE book.publisher = "人民邮电出版社" ) AS 人民邮电出版社

( SELECT COUNT(*) FROM book WHERE book.publisher = "机械工业出版社" ) AS 机械工业出版社

( SELECT COUNT(*) FROM book WHERE book.publisher = "清华大学出版社" ) AS 清华大学出版社

( SELECT COUNT(*) FROM book WHERE book.publisher = "电子工业出版社" ) AS 电子工业出版社

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 'SQL Query

SELECT
( SELECT COUNT(*) FROM book WHERE book.publisher = "æ' at line 1

我的解答思路和尝试过的方法

我在想是不是查询条件的问题？

Answer 1

你这个需求，用这条SQL搞定
SELECT publisher,COUNT(*) FROM book group by publisher;