编辑代码

CREATE DATABASE test;
use test;

CREATE TABLE TABLE1
(
    STOCK varchar(20),
    SYMBOL char(6),
    SHARETYPE char(1),
    TRADEDATE date,
    PRICE decimal(10,2)
);

insert into TABLE1(stock,symbol,sharetype,tradedate,price) values('平安银行','000001','A','2021-05-20',69.97);
insert into TABLE1(stock,symbol,sharetype,tradedate,price) values('长安B','200625','B','2021-05-20',7.11);
insert into TABLE1(stock,symbol,sharetype,tradedate,price) values('ST星源','000005','A','2021-05-20',1.82);
insert into TABLE1(stock,SHARETYPE)values('比亚迪','A');
alter TABLE TABLE1 add(PROVINCE varchar(10));
update TABLE1 set PRICE=70.2 where STOCK='平安银行';
update TABLE1 set PRICE=70.15,symbol='000002' where STOCK='平安银行';
delete from TABLE1 where STOCK='平安银行';
delete from TABLE1;

CREATE TABLE TABLE2 (
    stock varchar(20),
    symbol char(6),
    SHARETYPE char(1),
    TRADEDATE date,
    PRICE decimal(10,2),
    PROVINCE varchar(20)
);

INSERT INTO TABLE2 (STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE, PROVINCE) 
VALUES ('ST星源', '000005', 'A', '2023-01-01', 1.82, '广东省');

INSERT INTO TABLE2 (STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE, PROVINCE) 
VALUES ('北京城乡', '600861', 'A', '2023-01-01', 14.38, '北京市');

INSERT INTO TABLE2 (STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE, PROVINCE) 
VALUES ('三环集团', '300408', 'A', '2023-01-01', 37.41, '广东省');

INSERT INTO TABLE2 (STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE, PROVINCE) 
VALUES ('万科A', '000002', 'A', '2023-01-01', 26.77, '广东省');

INSERT INTO TABLE2 (STOCK, SYMBOL, SHARETYPE, TRADEDATE, PRICE, PROVINCE) 
VALUES ('南玻B', '200012', 'B', '2023-01-01', 3.58, '广东省');

update TABLE2 set price=16.25 where stock='平安银行';
delete from TABLE2 where stock='B';
delete from TABLE2 where stock='平安银行';
insert into TABLE2 (stock,symbol,sharetype,price,PROVINCE)VALUES('平安银行',000001,'A',16.25,'广东省');

CREATE TABLE TABLE3 (
    Bankcd char(6),
    Shortbnm varchar(20),
    Stkcd char(6),
    Typrep char(1),
    Cash decimal(18, 2)
);

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


DELETE FROM TABLE3
WHERE Typrep = 'D';


INSERT INTO TABLE3 (Bankcd, Shortbnm, Stkcd, Typrep, Cash)
VALUES ('000014', '招商银行', '600036', 'B', 599416000000);