- 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');
