mysql

1、删除某一个表

DELETE FROM  gift_certificate

2、删除某一个表的某一行

DELETE FROM  gift_certificate WHERE giftCertificateNo="123456789"

3、

INSERT INTO gift_certificate (giftCertificateNo,purchaser,recipient,isSentByEmail,giftCertAmt,remainedAmt,giftType,STATUS,VERSION,m10Amt,m11Amt) VALUES('1123456789','N/A','N/A',1,500,500,1,2,0,30,30);
SELECT * FROM gift_certificate WHERE giftCertificateNo='1123456789'

posted @ 2014-09-30 12:05  kin2321  阅读(144)  评论(0)  编辑  收藏  举报