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 TRBLE1 VALUES('长安B','200625','B','2021-05-20',7.11);
INSERT INTO TRBLE1 VALUES('ST星源','000005','A''2021-05-20',1.82);
insert into TABLE1(stock,sharetype) values('比亚迪','A');
select * from TABLE1;