Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Feb 9th, 2010 | Syntax: None | Size: 0.34 KB | Hits: 30 | Expires: Never
Copy text to clipboard
  1. CREATE TABLE products (
  2.         id int(11) NOT NULL auto_increment,
  3.         Description_article varchar(255) NULL,
  4.         Price CHAR(20) NOT NULL,
  5.         Total DOUBLE(16,2) NOT NULL,
  6.         PRIMARY KEY(Description_article, Total));
  7. )
  8. INSERT INTO products VALUES ('description of product 1',1.00,''),('description of product 2',1.50,''),('description of product 3',1.50,'');