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