多表连接时统计去重之后的数据

Tencent / Biny

Biny is a tiny, high-performance PHP framework for web applications

BSD 3-Clause "New" or "Revised" License

1.69k stars 259 forks source link

Open wallance1130 opened 5 years ago

wallance1130 commented 5 years ago

大大，使用下面语句addition([['sum'=>['use_times'=>'usetimes'],'count'=>['userid'=>'users','project'=>'projects']]]) count统计不重复的userid和project个数，并没有去重，是为什么呢

billge1205 commented 5 years ago

在addition里 count是不去重的用distinct会去重

billge1205 commented 5 years ago

另外可以在语句执行前添加 TXEvent::on(onSql) 来添加数据库调试事件会在浏览器console中打印出最终执行的sql语句

wallance1130 commented 5 years ago

求指导一下，怎么在addtion中用count(distinct(userid))这种呢

billge1205 commented 5 years ago

->addition([['sum'=>['use_times'=>'usetimes'],'distinct'=>['userid'=>'users','project'=>'projects']]]) 这样既可

wallance1130 commented 5 years ago

谢谢大佬!