sql.txt

用户可以添加商品

create database product;
use product;
CREATE TABLE Product(
 id 		INT AUTO_INCREMENT PRIMARY KEY,
 name 		VARCHAR(100),
 size		VARCHAR(60),
 unit           VARCHAR(20),
 content        VARCHAR(60),
 product_factory 	VARCHAR(60),
 product_supply  VARCHAR(60),
 color           VARCHAR(10),
 price_in        FLOAT,
 price_agent     FLOAT,
 price_sale      FLOAT,
 price_detail    FLOAT,
 specification  text,
 note		text,
 createDay 	DATE,
);