mysql数据库

UPDATE gift_certificate gc
SET gc.`status` = 1,
gc.`remainedAmt` = 1000,
gc.`m1Amt` = 80,
gc.`m2Amt` = 80,
gc.`m3Amt` = 80,
gc.`m4Amt` = 80,
gc.`m5Amt` = 80,
gc.`m6Amt` = 80,
gc.`m7Amt` = 80,
gc.`m8Amt` = 80,
gc.`m9Amt` = 80,
gc.`m10Amt` = 80,
gc.`m11Amt` = 80,
gc.`m12Amt` = 120
WHERE gc.`giftType` = 2;

统计一下数据

SELECT gc.`giftCertificateId`,COUNT(gc.`giftCertificateId`) AS coun FROM gift_certificate gc WHERE gc.`giftType` = 2;

或者

SELECT giftCertificateId,COUNT(giftCertificateId) AS coun FROM gift_certificate  WHERE giftType = 2;

 

//SELECT  productSkuId FROM WHERE price="%55%";