SELECT COUNT(s_dayreport.*) FROM s_dayreport INNER JOIN s_subuser ON s_dayreport.userId = s_subuser.userId WHERE s_subuser.mgrId = 63错误信息:
Query : select count(s_dayreport.*) from s_dayreport inner join s_subuser on s_dayreport.userId = s_subuser.userId where s_subuser.mgrId...
Error Code : 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 '*) from s_dayreport inner join s_subuser on s_dayreport.userId = s_subuser.userI' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
我的目标就是返回满足后面条件的s_dayreport里的数据的数量。谢谢!
Query : select count(s_dayreport.*) from s_dayreport inner join s_subuser on s_dayreport.userId = s_subuser.userId where s_subuser.mgrId...
Error Code : 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 '*) from s_dayreport inner join s_subuser on s_dayreport.userId = s_subuser.userI' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
我的目标就是返回满足后面条件的s_dayreport里的数据的数量。谢谢!
解决方案 »
- MySQL5.0.15
- 有没有办法可以在改变一列数据的同时自动改变另一列数据
- 剖析:MySQL的左连接、右连接、等值连接异同
- 求简单SQL语句,(同一个表中复制记录)可以在phpmyadmin中执行
- mysql求和和update的问题
- 关于show processlist的问题
- MySQL短时间大量插入,跟新数据出现异常,拒绝连接。帮个忙!!谢谢 back_log
- 搞错了分数,select substring(sendtime,1,8) ,count(*) from (select sendtime c from hasms_mo) group by substring(sendtime,1,8) ;为
- 查询 # [displayid相同的记录, 把 pid 值比较小的记录选出来]
- mysql可以启动,但不兼容,怎么解决
- mysql where 中文字段问题
- 大家看看我这个存储过程中如何加入事务控制?
SELECT COUNT(*) FROM s_dayreport where exists(select 1 from s_subuser where s_subuser.mgrId = 63 and s_dayreport.userId = s_subuser.userId )
不知道这里 select 1 什么意思?