编辑代码

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(stock,symbol,sharetype,tradedate,price) values('长
安B','200625','B','2021-05-20',7.11);
insert into table1(stock,symbol,sharetype,tradedate,price) values('S
T星源','000005','A','2021-05-20',1.82);
insert into table1(stock,sharetype) values('比亚迪','A');
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='平安银行';
delete from table1 where stock='平安银行';
delete from table1;
create table table2
(
    stock varchar(20),
    symbol char(6),
    sharetype char(1),
    tradedate date,
    price decimal(10,2),
    province VARCHAR(10)
);
insert into table2(stock,symbol,sharetype,price,province) values('ST星
源','000005','A',1.82,'广东省');
insert into table2(stock,symbol,sharetype,price,province) values('北京
城乡','600861','A',14.38,'北京市');
insert into table2(stock,symbol,sharetype,price,province) values('三环
集团','300408','A',37.41,'广东省');
insert into table2(stock,symbol,sharetype,price,province) values('万科
A','000002','A',26.77,'广东省');
insert into table2(stock,symbol,sharetype,price,province) values('南玻
B','200012','B',3.58,'广东省');
update table2 set price=16.25 where stock='平安银行';
delete from table2 where stock='B';
delete from table2 where stock='平安银行';
insert into table2(stock,symbol,sharetype,price,province) values('平安
银行','000001','A',16.25,'广东省');
delete from table2;
create table table3
(
    stock varchar(20),
    symbol char(6),
    sharetype char(1),
    tradedate date,
    price decimal(10,2),
    province VARCHAR(10)
);
insert into table2(stock,symbol,sharetype,price,province) values('北京
银行','000021'