SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE `db` ( `atticNo` varchar(50) NOT NULL, `name` varchar(20) NOT NULL, `price` int NOT NULL, `productdesc` varchar(10) NOT NULL, `upc` int NOT NULL ) E INSERT INTO `db` (`AtticNo`, `Name`, `Price`, `ProductDesc`, `UPC`) VALUES ('D44123431', 'Nike React Vision', 120.00, 'Black, Textile & Synthetic Upper/Synthetic Sole', 196154770125), ('D44123432', 'Nike Air Max 90', 145.00, 'Black, Leather', 196152633811), ('D44123433', 'On Running Cloud X 3', 130.00, 'Green, Textile & Synthetic Upper/Synthetic Sole', 7630419100508), ('D44123434', 'Crocs Classic Clog', 40.00, 'Black, Synthetic Upper/ Synthetic Sole', 841158002481), ('D44123435', 'Nike Air Huarache', 115.00, 'Green, Textile & Synthetic Upper/Synthetic Sole', 196152602190), ('D44123436', 'Under Armour Pants', 70.00, 'Black, Polyester', 195253092541) ;