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('00002','产品B',1239.87,208.24,20201020,80.67,19.3,2.71);