CREATE DATABASE test;
use test;
create table table3
(
Bankcd varchar(20),
Shortbnm varchar(20),
Stkcd char(6),
Typrep char(1),
Cash decimal(15,2)
);
insert into table3(Bankcd,Shortbnm,Stkcd,Typrep,Cash) values('000027','南京
银行','601009','B','105220607000.00');
insert into table3(Bankcd,Shortbnm,Stkcd,Typrep,Cash) values('000027','南京
银行','601009','C','93065245000.00');
insert into table3(Bankcd,Shortbnm,Stkcd,Typrep,Cash) values('000027','南京
银行','601009','A','106225841000.00');
insert into table3(Bankcd,Shortbnm,Stkcd,Typrep,Cash) values('000084','贵阳
银行','601997','D','41210720000.00');
insert into table3(Bankcd,Shortbnm,Stkcd,Typrep,Cash) values('000021','北京
银行','601169','B','184491000000.00');
insert into table3(Bankcd,Shortbnm,Stkcd,Typrep,Cash) values('000077','杭州
银行','600927','D','68901675000.00');
update table3 set Stkcd='600926'where Bankcd='杭州银行';
delete from table3 where typrep='D';
insert into table3(Bankcd,Shortbnm,Stkcd,Typrep,Cash) values('000014','招商
银行','600036','B','599416000000.00');