编辑代码

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

INSERT INTO TABLE3(Banked,Shorthrun,Siked,Typrep,Cash) VALUES('000021','北京银行','601169','B','184491000000')
INSERT INTO TABLE3(Banked,Shorthrun,Siked,Typrep,Cash) VALUES('000077','杭州银行','600927','D','68901675000')