topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

basic-mysql-15-ch15-TryItOut.sql / sql



  
  /* Chapter 15 - Try It Out sections */
  
  /* Try It Out: Optimizing Performance of a SELECT Statement */
  
  CREATE TABLE Cities
  (
     CityID SMALLINT NOT NULL PRIMARY KEY,
     CityName VARCHAR(20) NOT NULL
  )
  ENGINE=INNODB;
  
  INSERT INTO Cities
  VALUES (101, 'Seattle'), (102, 'Redmond'), (103, 'Bellevue'),
  (104, 'Kent'), (105, 'Kirkland');
  
  CREATE TABLE CustCity
  (
     CustID SMALLINT NOT NULL,
     CityID SMALLINT NOT NULL
  )
  ENGINE=INNODB;
  
  INSERT INTO CustCity
  VALUES (1, 104), (2, 101), (3, 104),
  (4, 103), (5, 102), (6, 105);
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.