SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE produkte(produktID INT NOT NULL AUTO_INCREMENT,produktname VARCHAR(40) NOT NULL, lieferantenID INT NULL, kategorieID INT NULL, einheit VARCHAR(20) NULL, preis DECIMAL(19, 4) NULL, lagerbestand SMALLINT NULL, bestellmenge SMALLINT NULL, meldebestand SMALLINT NULL, auslaufware TINYINT NOT NULL, PRIMARY KEY(produktID)); INSERT INTO produkte (produktID, produktname, lieferantenID, kategorieID, einheit, preis, lagerbestand, bestellmenge, meldebestand, auslaufware) VALUES(1, 'Chai', 8, 1, '10 boxes x 30 bags', 18.0, 39, 0, 10, 1),(2, 'Chang', 1, 1, '24 - 12 oz bottles', 19.0, 17, 40, 25, 1),(3, 'Aniseed Syrup', 1, 2, '12 - 550 ml bottles', 10.0, 13, 70, 25, 0),(4, 'Chef Anton\'s Cajun Seasoning', 2, 2, '48 - 6 oz jars', 22.0, 53, 0, 0, 0),(5, 'Chef Anton\'s Gumbo Mix', 2, 2, '36 boxes', 21.35, 0, 0, 0, 1),(6, 'Grandma\'s Boysenberry Spread', 3, 2, '12 - 8 oz jars', 25.0, 120, 0, 25, 0),(7, 'Uncle Bob\'s Organic Dried Pears', 3, 7, '12 - 1 lb pkgs.', 30.0, 15, 0, 10, 0),(8, 'Northwoods Cranberry Sauce', 3, 2, '12 - 12 oz jars', 40.0, 6, 0, 0, 0),(9, 'Mishi Kobe Niku', 4, 6, '18 - 500 g pkgs.', 97.0, 29, 0, 0, 1),(10, 'Ikura', 4, 8, '12 - 200 ml jars', 31.0, 31, 0, 0, 0),(11, 'Queso Cabrales', 5, 4, '1 kg pkg.', 21.0, 22, 30, 30, 0),(12, 'Queso Manchego La Pastora', 5, 4, '10 - 500 g pkgs.', 38.0, 86, 0, 0, 0),(13, 'Konbu', 6, 8, '2 kg box', 6.0, 24, 0, 5, 0),(14, 'Tofu', 6, 7, '40 - 100 g pkgs.', 23.25, 35, 0, 0, 0),(15, 'Genen Shouyu', 6, 2, '24 - 250 ml bottles', 13.0, 39, 0, 5, 0),(16, 'Pavlova', 7, 3, '32 - 500 g boxes', 17.45, 29, 0, 10, 0),(17, 'Alice Mutton', 7, 6, '20 - 1 kg tins', 39.0, 0, 0, 0, 1),(18, 'Carnarvon Tigers', 7, 8, '16 kg pkg.', 62.5, 42, 0, 0, 0),(19, 'Teatime Chocolate Biscuits', 8, 3, '10 boxes x 12 pieces', 9.2, 25, 0, 5, 0),(20, 'Sir Rodney\'s Marmalade', 8, 3, '30 gift boxes', 81.0, 40, 0, 0, 0),(21, 'Sir Rodney\'s Scones', 8, 3, '24 pkgs. x 4 pieces', 10.0, 3, 40, 5, 0),(22, 'Gustaf\'s Knäckebröd', 9, 5, '24 - 500 g pkgs.', 21.0, 104, 0, 25, 0),(23, 'Tunnbröd', 9, 5, '12 - 250 g pkgs.', 9.0, 61, 0, 25, 0),(24, 'Guaraná Fantástica', 10, 1, '12 - 355 ml cans', 4.5, 20, 0, 0, 1),(25, 'NuNuCa Nuß-Nougat-Creme', 11, 3, '20 - 450 g glasses', 14.0, 76, 0, 30, 0),(26, 'Gumbär Gummibärchen', 11, 3, '100 - 250 g bags', 31.23, 15, 0, 0, 0),(27, 'Schoggi Schokolade', 11, 3, '100 - 100 g pieces', 43.9, 49, 0, 30, 0),(28, 'Rössle Sauerkraut', 12, 7, '25 - 825 g cans', 45.6, 26, 0, 0, 1),(29, 'Thüringer Rostbratwurst', 12, 6, '50 bags x 30 sausgs.', 123.79, 0, 0, 0, 1),(30, 'Nord-Ost Matjeshering', 13, 8, '10 - 200 g glasses', 25.89, 10, 0, 15, 0),(31, 'Gorgonzola Telino', 14, 4, '12 - 100 g pkgs', 12.5, 0, 70, 20, 0),(32, 'Mascarpone Fabioli', 14, 4, '24 - 200 g pkgs.', 32.0, 9, 40, 25, 0),(33, 'Geitost', 15, 4, '500 g', 2.5, 112, 0, 20, 0),(34, 'Sasquatch Ale', 16, 1, '24 - 12 oz bottles', 14.0, 111, 0, 15, 0),(35, 'Steeleye Stout', 16, 1, '24 - 12 oz bottles', 18.0, 20, 0, 15, 0),(36, 'Inlagd Sill', 17, 8, '24 - 250 g jars', 19.0, 112, 0, 20, 0),(37, 'Gravad lax', 17, 8, '12 - 500 g pkgs.', 26.0, 11, 50, 25, 0),(38, 'Côte de Blaye', 18, 1, '12 - 75 cl bottles', 263.5, 17, 0, 15, 0),(39, 'Chartreuse verte', 18, 1, '750 cc per bottle', 18.0, 69, 0, 5, 0),(40, 'Boston Crab Meat', 19, 8, '24 - 4 oz tins', 18.4, 123, 0, 30, 0),(41, 'Jack\'s New England Clam Chowder', 19, 8, '12 - 12 oz cans', 9.65, 85, 0, 10, 0),(42, 'Singaporean Hokkien Fried Mee', 20, 5, '32 - 1 kg pkgs.', 14.0, 26, 0, 0, 1),(43, 'Ipoh Coffee', 20, 1, '16 - 500 g tins', 46.0, 17, 10, 25, 0),(44, 'Gula Malacca', 20, 2, '20 - 2 kg bags', 19.45, 27, 0, 15, 0),(45, 'Rogede sild', 21, 8, '1k pkg.', 9.5, 5, 70, 15, 0),(46, 'Spegesild', 21, 8, '4 - 450 g glasses', 12.0, 95, 0, 0, 0),(47, 'Zaanse koeken', 22, 3, '10 - 4 oz boxes', 9.5, 36, 0, 0, 0),(48, 'Chocolade', 22, 3, '10 pkgs.', 12.75, 15, 70, 25, 0),(49, 'Maxilaku', 23, 3, '24 - 50 g pkgs.', 20.0, 10, 60, 15, 0),(50, 'Valkoinen suklaa', 23, 3, '12 - 100 g bars', 16.25, 65, 0, 30, 0),(51, 'Manjimup Dried Apples', 24, 7, '50 - 300 g pkgs.', 53.0, 20, 0, 10, 0),(52, 'Filo Mix', 24, 5, '16 - 2 kg boxes', 7.0, 38, 0, 25, 0),(53, 'Perth Pasties', 24, 6, '48 pieces', 32.8, 0, 0, 0, 1),(54, 'Tourtière', 25, 6, '16 pies', 7.45, 21, 0, 10, 0),(55, 'Pâté chinois', 25, 6, '24 boxes x 2 pies', 24.0, 115, 0, 20, 0),(56, 'Gnocchi di nonna Alice', 26, 5, '24 - 250 g pkgs.', 38.0, 21, 10, 30, 0),(57, 'Ravioli Angelo', 26, 5, '24 - 250 g pkgs.', 19.5, 36, 0, 20, 0),(58, 'Escargots de Bourgogne', 27, 8, '24 pieces', 13.25, 62, 0, 20, 0),(59, 'Raclette Courdavault', 28, 4, '5 kg pkg.', 55.0, 79, 0, 0, 0),(60, 'Camembert Pierrot', 28, 4, '15 - 300 g rounds', 34.0, 19, 0, 0, 0),(61, 'Sirop d\'érable', 29, 2, '24 - 500 ml bottles', 28.5, 113, 0, 25, 0),(62, 'Tarte au sucre', 29, 3, '48 pies', 49.3, 17, 0, 0, 0),(63, 'Vegie-spread', 7, 2, '15 - 625 g jars', 43.9, 24, 0, 5, 0),(64, 'Wimmers gute Semmelknödel', 12, 5, '20 bags x 4 pieces', 33.25, 22, 80, 30, 0),(65, 'Louisiana Fiery Hot Pepper Sauce', 2, 2, '32 - 8 oz bottles', 21.05, 76, 0, 0, 0),(66, 'Louisiana Hot Spiced Okra', 2, 2, '24 - 8 oz jars', 17.0, 4, 100, 20, 0),(67, 'Laughing Lumberjack Lager', 16, 1, '24 - 12 oz bottles', 14.0, 52, 0, 10, 0),(68, 'Scottish Longbreads', 8, 3, '10 boxes x 8 pieces', 12.5, 6, 10, 15, 0),(69, 'Gudbrandsdalsost', 15, 4, '10 kg pkg.', 36.0, 26, 0, 15, 0),(70, 'Outback Lager', 7, 1, '24 - 355 ml bottles', 15.0, 15, 10, 30, 0),(71, 'Flotemysost', 15, 4, '10 - 500 g pkgs.', 21.5, 26, 0, 0, 0),(72, 'Mozzarella di Giovanni', 14, 4, '24 - 200 g pkgs.', 34.8, 14, 0, 0, 0),(73, 'Röd Kaviar', 17, 8, '24 - 150 g jars', 15.0, 101, 0, 5, 0),(74, 'Longlife Tofu', 4, 7, '5 kg pkg.', 10.0, 4, 20, 5, 0),(75, 'Rhönbräu Klosterbier', 12, 1, '24 - 0.5 l bottles', 7.75, 125, 0, 25, 0),(76, 'Lakkalikööri', 23, 1, '500 ml', 18.0, 57, 0, 20, 0),(77, 'Original Frankfurter grüne Soße', 12, 2, '12 boxes', 13.0, 32, 0, 15, 0); CREATE TABLE lieferanten (id INT(11) NOT NULL AUTO_INCREMENT,unternehmen VARCHAR(50) NULL DEFAULT NULL,nachname VARCHAR(50) NULL DEFAULT NULL,vorname VARCHAR(50) NULL DEFAULT NULL,email VARCHAR(50) NULL DEFAULT NULL,job_titel VARCHAR(50) NULL DEFAULT NULL,geschaeftsnummer VARCHAR(25) NULL DEFAULT NULL,telefon VARCHAR(25) NULL DEFAULT NULL,mobil VARCHAR(25) NULL DEFAULT NULL,fax_nummer VARCHAR(25) NULL DEFAULT NULL,adresse LONGTEXT NULL DEFAULT NULL,stadt VARCHAR(50) NULL DEFAULT NULL,bundesland VARCHAR(50) NULL DEFAULT NULL,plz VARCHAR(15) NULL DEFAULT NULL,region VARCHAR(50) NULL DEFAULT NULL,homepage LONGTEXT NULL DEFAULT NULL,bemerkungen LONGTEXT NULL DEFAULT NULL,anhaenge LONGBLOB NULL DEFAULT NULL,PRIMARY KEY(id)); INSERT INTO `lieferanten` (`id`, `unternehmen`, `nachname`, `vorname`, `email`, `job_titel`, `geschaeftsnummer`, `telefon`, `mobil`, `fax_nummer`, `adresse`, `stadt`, `bundesland`, `plz`, `region`, `homepage`, `bemerkungen`, `anhaenge`) VALUES (1, 'Lieferant A', 'Andersen', 'Elizabeth A.', NULL, 'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''), (2, 'Lieferant B', 'Weiler', 'Cornelia', NULL, 'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),(3, 'Lieferant C', 'Kelley', 'Madeleine', NULL, 'Sales Representative', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),(4, 'Lieferant D', 'Sato', 'Naoki', NULL, 'Marketing Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),(5, 'Lieferant E', 'Hernandez-Echevarria', 'Amaya', NULL, 'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),(6, 'Lieferant F', 'Hayakawa', 'Satomi', NULL, 'Marketing Assistant', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),(7, 'Lieferant G', 'Glasson', 'Stuart', NULL, 'Marketing Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),(8, 'Lieferant H', 'Dunton', 'Bryn Paul', NULL, 'Sales Representative', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),(9, 'Lieferant I', 'Sandberg', 'Mikael', NULL, 'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),(10, 'Lieferant J', 'Sousa', 'Luis', NULL, 'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''); -- Die Zeilen 1 - 6 müssen immer stehen bleiben!!!! Ab hier können die eigenen Befehle stehen: --
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear