编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE TABLE3 (
    Bankcd VARCHAR(10),
    Shortbnm VARCHAR(50),
    Stkcd VARCHAR(10),
    Typrep CHAR(1),
    Cash BIGINT
);
INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash)
VALUES ('000027', '南京银行', '601009', 'B', 105220607000);
INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash)
VALUES ('000027', '南京银行', '601009', 'C', 93065245000);
INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash)
VALUES ('000027', '南京银行', '601009', 'A', 106225841000);
INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash)
VALUES ('000084', '贵阳银行', '601997', 'D', 41210720000);
-- 新增北京银行的数据
INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash)
VALUES ('000021', '北京银行', '601169', 'B', 184491000000);
-- 新增杭州银行的数据
INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash)
VALUES ('000077', '杭州银行', '600927', 'D', 68901675000);
UPDATE TABLE3
SET Stkcd = '600926'
WHERE Bankcd = '000077' AND Shortbnm = '杭州银行';
-- 删除报表类型为D的信息
DELETE FROM TABLE3
WHERE Typrep = 'D';

-- 新增招商银行的数据
INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash)
VALUES ('000014', '招商银行', '600036', 'B', 599416000000);