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

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

原文地址:https://www.cnblogs.com/Mr-xy/p/10918450.html