Gift Card import available

Insert into sequence (sequence, purchaser, recipient, sequence, sequence, remainedamt, gifttype, status, version, m1amt, m2amt, m3amt, m4amt, m5amt, m6amt, m7amt, m8amt, m9amt, m10amt, m11amt, m12amt, customerid, registertime) values ('000000', 'n/A', 'n/A', 16940084, 1,500,500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,-2, '2017-10-09 14:00:00 ');
Insert into sequence (sequence, purchaser, recipient, sequence, sequence, remainedamt, gifttype, status, version, m1amt, m2amt, m3amt, m4amt, m5amt, m6amt, m7amt, m8amt, m9amt, m10amt, m11amt, m12amt, customerid, registertime) values ('ab74448351', 'n/A', 'n/A', 1,500,500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,-2, '2017-10-09 14:00:00 ');

 

Query a database

Select count (giftcertificateid) as num from gift_certificate where giftcertificateid >=22116;

 

Insert into coupon (promoruleid, couponno, issent, remainedtimes, status, Version) values (38, 'hq510528967 ', 0, 1, 0 );

 

Update a field

Update coupon set promoruleid = 79 where couponno = 'hq2017220091 ';

Gift Card import available