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-16-ch16-TryItOut.sql / sql



  
  /* Chapter 16 - Try It Out sections */
  
  /* Try It Out: Backing Up a Database to a Backup File */
  
  CREATE DATABASE VideoRentals;
  use VideoRentals;
  CREATE TABLE Videos
  (
     VideoID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
     VideoName VARCHAR(60) NOT NULL,
     Status ENUM('In', 'Out') NOT NULL
  ) 
  ENGINE=INNODB;
  
  INSERT INTO Videos (VideoName, Status)
  VALUES ('Out of Africa', 'In'),
  ('The Maltese Falcon', 'In'),
  ('The Rocky Horror Picture Show', 'Out'),
  ('A Room with a View', 'In'),
  ('Mash', 'Out');
[] 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.