CREATE DATABASE accountS_receivabie;
use accountS_receivabie;
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
);
insert into accounts_info()
values('00001','产品A',1240.87,208.24,20201020,80.67,19.3,2.71);
select*from accounts_info;