编辑代码

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

alter table TABLE1 ADD(PROVINCE VARCHAR(18));
update TABLE1 set price=70.2 where stock='平安银行';
update TABLE1 set price=70.15,symbol='000002' where stock='平安银行';
select *from TABLE1