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;