编辑代码

CREATE DATABASE account_receivabie;
use account_receivabie;
CREATE TABLE accounts_info (
	unid varchar(32)primary key,
	pname varchar(32),
	income float,
    cost_price float,
	sale_date date ,
    sale_num float,
    sale_price float,
    cost_price float);
);
insert into accounts_info(uuid,pname,income,cost,sale_date date,sale_num,sale_price,cost_price)
values('00002','产品B',1239.87,208.24,20201020,80.67,19.3,2.71);