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