fork download
  1. CREATE TABLE tblBook (
  2. ISBN int PRIMARY KEY,
  3. Title varchar(255) NOT NULL,
  4. Author varchar(255),
  5. PublicationYr varchar(255),
  6. Price int
  7. );
  8.  
  9. INSERT INTO tblBook (ISBN, BookTitle, Author, PublicationYr, Price)
  10. VALUES
  11. (1001, 'Anna Karenina', 'Leo Tolstoy', '2008-03-25', 3500),
  12. (1002, 'To Kill a Mockingbird', 'Harper Lee', '2010-07-30', 2750),
  13. (1003, 'The Great Gatsby', 'F. Scott Fitzgerald', NULL, 2000),
  14. (1004, 'One Hundred Years of Solitude', 'Gabriel Garcia Marquez', '2013-02-23', NULL),
  15. (1005, 'A Passage to India', 'E.M. Forster', '2009-05-09', 1750);
  16.  
  17.  
  18. SELECT * FROM tblBook;
Success #stdin #stdout #stderr 0.01s 5328KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Error: near line 9: table tblBook has no column named BookTitle