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');