自己储备SQL语句

UPDATE t_vip_giftcard SET uid = 1, act_time = "2012-09-06", valid = "2012-09-06" WHERE id = 1


INSERT INTO t_vip_giftcard (`card_num`, `value`, `remark`, `uid`,`password`,`act_time`,`remaining`,`buy_uid`, `valid`)
SELECT `card_num`, `value`, `remark`, `uid`,`password`,`act_time`,`remaining`, `buy_uid`, `valid`
FROM t_vip_giftcard
WHERE uid = 0;

DELETE FROM t_vip_giftcard WHERE VALUE IS NULL;t_vip_coupon