编辑代码

CREATE DATABASE test;
use test ;
create table TABLE3(
	BANKCD char(6),
	SHORTBNM char(5),
	STKCD char(7),
	TYPREP char(4),
    CASH char(20)
);

INSERT INTO TABLE3(Bankcd,Shortbnm,Stkcd,Typrep,Cash)VALUES(000027,'南京银行',601009,'B',1052206070000);
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);
select *from TABLE3;
UPDATE TABLE3 SET Stkcd=600926 WHERE Shortbnm='杭州银行';
select *from TABLE3;
DELETE FROM TABLE3 WHERE Typrep='D';
INSERT INTO TABLE3(Bankcd,Shortbnm,Stkcd,Typrep,Cash)VALUES(000014,'招商银行',600036,'B',599416000000);
select *from TABLE3;