编辑代码

CREATE DATABASE accounts_info;
use accounts_info;
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('00001','产品A',1240.87,209.24,20201021,82.67,19.3,2.71);
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);