- CREATE TABLE products (
- id int(11) NOT NULL auto_increment,
- Description_article varchar(255) NULL,
- Price CHAR(20) NOT NULL,
- Total DOUBLE(16,2) NOT NULL,
- PRIMARY KEY(Description_article, Total));
- )
- INSERT INTO products VALUES ('description of product 1',1.00,''),('description of product 2',1.50,''),('description of product 3',1.50,'');
