Question

请求select count(*) as count from pages时报错

请求const sql = `select * from pages;select count(*) as count from pages`，
在navicat里编辑查询没问题，
运行时报错Error: ER_PARSE_ERROR: 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 'select pages.id from pages' at line 1，实在是想不明白为什么，求解答
写错了，运行时报错应该是Error: ER_PARSE_ERROR: 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 'select count(*) as count from pages' at line 1

若以下回答无法解决问题，邀请你更新回答

Answer 1

count()是一个聚合函数，name是表名。这条语句是统计name这个表有多少条数据，并将查出的总数的列名为MyCount。

Answer 2

为什么要报错了