SQL Column 'count' not found.

select count(t1.id) from table t1 left join table2 t2 on t1.tid = t2.id

发现是别名问题

改为:select count(t1.id) as count from table t1 left join table2 t2 on t1.tid = t2.id

 

java.lang.IllegalArgumentException: argument type mismatch

是查询到的结果与返回类型不匹配

posted @   Mr_xYu  阅读(731)  评论(0编辑  收藏  举报
点击右上角即可分享
微信分享提示