qq_35872777的博客

分布式数据库中间件Mycat2(虚拟数据库类)

select date_format (createtime,'%Y-%m-%d'),pid,product_name, count(distinct if ( is_cost = 1,uid,null))'机构进件', count(if( is_cost = 1 and refund_cash_per_term is not null,uid,null))'批核', sum(if(is_cost = 1 and refund_cash_per_term is not null,refund_cash_pe

以root用户登录mysql，执行一下这条sql脚本即可解决问题 flush hosts

记录： mysql中创建数据库用户并且授权 grant select,UPDATE on localhost.* to 'test12'@"%" identified by "B2b1A2B3C.cig";