编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE TABLE4(
    STOCK varchar(30),
    SYMBOL char(6),
    SHARETYPE char(1),
    PRICE decimal(10,2),
    PROVINCE varchar(20)
);
INSERT INTO TABLE4(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)VALUES('平安银行','000001','A',69.97,'广东省');
INSERT INTO TABLE4(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)VALUES('长安B','200625','B',7.11,'重庆市');
INSERT INTO TABLE4(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)VALUES('比亚迪','002594','A',172.78,'广东省');
INSERT INTO TABLE4(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)VALUES