编辑代码

CREATE DATABASE IF NOT EXISTS finance;

USE finance;

CREATE TABLE IF NOT EXISTS TABLE3 (
    Bankcd VARCHAR(6),
    Shortbnm VARCHAR(50),
    Stkcd VARCHAR(10),
    Typrep CHAR(1),
    Cash DECIMAL(20, 2)
);

INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash) VALUES
('000027', '南京银行', '601009', 'B', 105220607000.00),
('000027', '南京银行', '601009', 'C', 93065245000.00),
('000027', '南京银行', '601009', 'A', 106225841000.00),
('000084', '贵阳银行', '601997', 'D', 41210720000.00);

INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash) VALUES
('000021', '北京银行', '601169', 'B', 184491000000.00),
('000077', '杭州银行', '600927', 'D', 68901675000.00);

UPDATE TABLE3 SET Stkcd = '600926' WHERE Bankcd = '000077';

DELETE FROM TABLE3 WHERE Typrep = 'D';
INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash) VALUES
('000014', '招商银行', '600036', 'B', 599416000000.00);