编辑代码

CREATE TABLE TABLE3 ( Bankcd CHAR(6),
    Shortbnnm VARCHAR(20),
    Stkcd CHAR(6),
    Typrep CHAR(1),
    Cash VARCHAR(20),
    TRADEDATE DATE,
    PRICE DECIMAL(10,2)
INSERT INTO TABLE3 (Bankcd, Shortbnnm, Stkcd, Typrep, Cash)
VALUES ('000027', '南京银行', '601009', 'B', '105220607000');

INSERT INTO TABLE3 (Bankcd, Shortbnnm, Stkcd, Typrep, Cash)
VALUES ('000027', '南京银行', '601009', 'C', '93065245000');

INSERT INTO TABLE3 (Bankcd, Shortbnnm, Stkcd, Typrep, Cash)
VALUES ('000027', '南京银行', '601009', 'A', '106225841000');

INSERT INTO TABLE3 (Bankcd, Shortbnnm, Stkcd, Typrep, Cash)
VALUES ('000084', '贵阳银行', '601997', 'D', '41210720000');
UPDATE TABLE3
SET Stkcd = '600926'
WHERE Bankcd = '000077' AND Shortbnnm = '杭州银行';
DELETE FROM TABLE3 WHERE Typrep = 'D';
INSERT INTO TABLE3 (Bankcd, Shortbnnm, Stkcd, Typrep, Cash)
VALUES ('000014', '招商银行', '600036', 'B', '599416000000');