请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
用户sxjlx97327076(uid:631903)
职业资格认证:尚未取得认证
  • 现在富文本中文字开头是顶格的,我想让它显示时开头空两个格以达到美观,请问应该怎么做?
  • 数据库的字段是month_id,现在想取出当前月的数据,请问在查询条件中应该怎么写呢?
  • 如图我不想显示黑框里现金后面的那串数字,应该怎么去掉呢?
  • 数据库里面是有数据的,但是查询到结果就是空代码如下select sum(amount)/10000 as 微信月支付from app_db.payinfo_hywhere calmonth = translate(substr(current_date() , 1 ,7 ),'_','')  and mpay_type_txt  = "微信"
  • SELECT a.mpay_type_txt,a.银联卡日支付, b.银联卡月支付, c.银联卡年支付FROM (select mpay_type_txt, sum(amount)/10000 as '银联卡日支付' from lsyw_yp_payinfo_d_hy group by mpay_type_txtwhere calday =translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,10 ),'-','') and mpay_type_txt="银联卡")afull joinfrom(select mpay_type_txt, sum(amount)/10000 as '银联卡月支付' from lsyw_yp_payinfo_hy group by mpay_type_txtwhere calmonth =translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,7 ),'-','') and mpay_type_txt="银联卡")bon a.mpay_type_txt = b.mpay_type_txtfull join(select mpay_type_txt, sum(amount)/10000 as '银联卡年支付' from lsyw_yp_payinfo_d_hy group by mpay_type_txtwhere calday =translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,4 ),'-','') and mpay_type_txt="银联卡")con a.mpay_type_txt =c.mpay_type_txt
  • 代码如下,SELECT calmonth,mpay_type_txt,sum(amount)/10000 FROM app_db.zhy_fyyw_fy_payinfo_hy  where calmonth=translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,7 ) and mpay_type_txt!="总金额" group by mpay_type_txt
  • 代码如下select '销量', a.xy,a.ax,a.zx from(select xy_sale as xy, ax_sale as ax, zx_sale as zx from app_db.yp_xs_d_his_hy where calday=translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,10 ),'-','')) as aunion select '收入', a.xy,a.ax,a.zx from(select xy_income as xy, ax_income as ax, zx_income as zx from app_db.yp_xs_d_his_hy where calday=translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,10 ),'-','')) as aunion select '毛利', a.xy,a.ax,a.zx from(select xy_gross as xy, ax_gross as ax, zx_gross as zx from app_db.yp_xs_d_his_hy where calday=translate(substr(date_sub(CURRENT_DATE(),1) , 1 ,10 ),'-','')) as a

155

3

155

10

个人成就
内容被浏览48,720
加入社区4年121天
返回顶部