编辑代码

CREATE DATABASE test;
use test;
create table TABLE1 (
    stock varchar(20),
    symbol char(6),
    sharetype char(1),
    traddate 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);