Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Feb 9th, 2010 | Syntax: None | Size: 0.33 KB | Hits: 25 | 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 DOUBLE(16,2) NOT NULL,
  5.         Total DOUBLE(16,2) NOT NULL,
  6.         PRIMARY KEY(id));
  7.  
  8. 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');