SELECT SUM(if(gy is null,quan,gy)) FROM `表名` WHERE time='20220214' AND rjid='DTH' AND name='前腿瘦肉' AND dm<>''
查询 计数(if(判断条件，为真执行，为假执行)) FROM jl WHERE 查询条件SELECT SUM(if(判断列值,为真取,为假取)) FROM `表名`...
用于小程序页面倒计时的一个JSWXML:<text style="color:{{djscolor}}">当前剩余时间：{{nub}}秒</text>
JS:Page({
data: {
nub:60
},
onLoad: function (options) {
var that = this
that.setD...