sample.mysql.txt 367 B

12345678
  1. CREATE TABLE shop (
  2. article INT(4) UNSIGNED ZEROFILL DEFAULT '0000' NOT NULL,
  3. dealer CHAR(20) DEFAULT '' NOT NULL,
  4. price DOUBLE(16,2) DEFAULT '0.00' NOT NULL,
  5. PRIMARY KEY(article, dealer));
  6. INSERT INTO shop VALUES
  7. (1,'A',3.45),(1,'B',3.99),(2,'A',10.99),(3,'B',1.45),
  8. (3,'C',1.69),(3,'D',1.25),(4,'D',19.95);