为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:WINDOWS
【CPU】:
【问题描述】*:
[执行语句1]:
SELECT
count(qb.question_source = ‘simulate’ ) AS “simulateCount”
FROM exam_question_bank qb
执行失败(语句1)
第 2 行, 第 26 列[=]附近出现错误[-2007]:
语法分析出错
1条语句执行失败
mysql尽是一些不标准的奇葩语法
SELECT
count(*) AS “simulateCount”
FROM exam_question_bank qb where qb.question_source = ‘simulate’
SELECT count(1) AS “simulateCount” FROM exam_question_bank qb where qb.question_source = ‘simulate’