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.8 7,208.24 ,20201020, 80.67,19.3,2.71);