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 TABLE1 VALUES('长安B','200625','B','2021-05-20',7.11);
INSERT INTO TABLE1 VALUES('ST星源','000005','A','2021-05-20',1.82);
insert into TABLE1(stock,sharetype) values('比亚迪','A');
select * from TABLE1;
alter table TABLE1 ADD(PROVINCE VARCHAR(10));
update TABLE1 set price=70.2 where stock='平安银行';
update TABLE1 set price=70.15,symbol='000002' where stock='平安银行';
select * from TABLE1;