编辑代码

create database account_receivable;
use account_receivable;
create table accounts_info(
uuid varchar(32)primary key,
pname varchar(32),
income float,
cost float,
sale_date date,
sale_num float,
sale_price float,
cost_price float);
insert into accounts_info(
uuid,pname,income,cost,sale_date,
sale_num,sale_price,cost_price)
values('00002','产品B',1239.87,
208.24,20201020,80.67,19.3,2.71);
select*from accounts_info;
insert into accounts_info()
values('00001','产品A',1240.87,
209.24,20201021,82.67,19.3,2.71);
select*from accounts_info;
insert into accounts_info()
values('00003','产品C',8893.27,
7653.59,20201019,89.96,98.97,85.17);
insert into accounts_info()
values('00004','产品D',1171.03,
686.7,20201011,71.33,16.42,0.00);
insert into accounts_info()
values('00005','产品E',1428.47,
6324.22,20201025,55.85,25.85,113.24);
insert into accounts_info()
values('00006','产品F',9519.28,
2345.25,20201029,45.61,208.72,51.42);
insert into accounts_info()
values('00007','产品G',2288.56,
2679.57,20201021,12.97,176.44,206.59);
insert into accounts_info()
values('00008','产品H',8177.03,
3062.68,20201023,68.82,118.82,44.5);
insert into accounts_info()
values('00009','产品I',7920.36,
3803.42,20201026,14.29,554.27,266.17);
insert into accounts_info()
values('00010','产品J',6185.89,
1040.76,20201001,41.86,144.32,24.28);
select*from accounts_info;
select*from accounts_info where sale_date>'20201027';
select uuid,sale_date,cost_price from accounts_info where cost_price>'2';
select*from accounts_info where pname='产品A' and sale_date='20201021';
update accounts_info set sale_price=20 where uuid='00001';
update accounts_info set cost_price='3' where pname='产品J' and sale_date='20201001';