sum(SELECT `item_real` FROM `budgetcontrol` WHERE `department` = 'fi' LIMIT 0 , 6)
结果为:#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 'sum(SELECT `item_real` FROM `budgetcontrol` WHERE `department` = 'fi' LIMIT 0 , ' at line 1
请问是什么问题?
解决方案 »
- 帮忙看个触发器mysql
- sql正则表达式替换
- MySQL约束语句没效果, 帮我看看哪里有问题
- binlog_format=mixed导致同步停止(denniswwh请进)
- mysql的text字段类型用来存放文章的话长度设置成多少合适还是不用设?
- jsp连接mysql时出现HTTP Status 500 - 高手请进
- 请问如何远程让mysql重启?谢谢
- 哎,PostgreSql(windows)的数据库效率太不高了!
- 高分请教mysql网络服务器模型是什么样子的?
- 求教:access数据库转SQL SERVER数据库
- linux下安装mysql插件 出现ERROR 1146 (42S02): Table 'mysql.plugin' doesn't exist
- 又是 Can't connect to MySQL server on 'localhost' (10061),刷新又正常
FROM `budgetcontrol`
WHERE `department` = 'fi'
LIMIT 0 , 6
select sum() from (select <> from t limit 0, 6) newT