SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE apps ( name char(25), priceMonthly decimal(5,2), billDay char(10), governBody char(25), validSecurity boolean ); INSERT INTO apps VALUES ('Netflix', 15.49, '1st', 'various', TRUE); INSERT INTO apps VALUES ('Hulu', 5.99, '2nd', 'Disney', TRUE); INSERT INTO apps VALUES ('Amazon Prime', '8.99', '3rd', 'Amazon.com', TRUE); SELECT * from apps; CREATE TABLE fruit ( nameGeneral char(25), nameSpecific char(25), color char(25), isSweet boolean, localCost decimal(5,2), originCountry char(25) ); INSERT INTO fruit VALUES ('Apple', 'Granny Smith', 'Green', FALSE, .99, 'USA'); INSERT INTO fruit VALUES ('Orange', 'Clementine', 'Orange', TRUE, .49, 'USA'); INSERT INTO fruit VALUES ('Pear', 'Common Pear', 'Green', TRUE, 1.50, 'UK'); SELECT * from fruit;