SQLize Online / PHPize Online  /  SQLtest Online

/* Joe Francis R. Marco BSIT - 2A */ CREATE TABLE tblBooks ([ISBN] int, [TITLE] varchar(15), [AUTHOR] varchar(20), [PULICATION YEAR] varchar(20), [PRICE] int); INSERT INTO tblBooks ([ISBN], [TITLE], [AUTHOR], [PULICATION YEAR], [PRICE]) VALUES ('1001', 'Anna Karenina', 'Leo Tolstory', '2008-03-25', 3500.00), ('1002', 'To Kill a Mockingbird', 'Harper Lee', '2010-07-30', 2750.00), ('1003', 'The Great Gatsby', 'F. Scott Fitzgerald', NULL, 2000.00), ('1004', 'One Hundred Years of Solitude', 'Gabriel Garcia Marquez', '2013-02-23', NULL), ('1005', 'A Passage to India', 'E.M. Folster', '2009-05-09', 1750.00); SELECT ISBN, TITLE, AUTHOR, PULICATION YEAR, PRICE FROM tblBooks;