CREATE DATABASE account;
use accounts_receivable;
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,89.67,19.3,2.71
);