编辑代码


CREATE DATABASE accounts_receivable;
use accounts_receivable;
CREATE TABLE accounts_info(
    uuid varchar32)primary key,
    pname varchar32),
    income floatcost 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,89.67,19.3,2.71
);