CREATE TABLE products (

        id int(11) NOT NULL auto_increment,

        Description_article varchar(255) NULL,

        Price DOUBLE(16,2) NOT NULL,

        Total DOUBLE(16,2) NOT NULL,

        PRIMARY KEY(id));

 

INSERT INTO products VALUES (id,'description of product 1',1.00,''),(id,'description of product 2',1.50,''),(,id'description of product 3',1.50,'foo');