SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE IF NOT EXISTS `Kunde` ( `ID` int(6) unsigned NOT NULL, `Vorname` varchar(20), `Nachname` varchar(20), `Geburtsdatum` date, `Strasse` varchar(25), `Hausnummer` varchar(5), `PLZ` varchar(5), `Stadt` varchar(25), `Telefon` varchar(25), `EMail` varchar(40), `Stromverbrauch` int(6) unsigned, `Gasverbrauch`int(6) unsigned, PRIMARY KEY (`ID`) ) DEFAULT CHARSET=utf8; INSERT INTO `Kunde` (`ID`,`Vorname`,`Nachname`, `Geburtsdatum`,`Strasse`,`Hausnummer`,`PLZ`,`Stadt`,`Telefon`,`EMail`,`Stromverbrauch`,`Gasverbrauch`) VALUES (1, 'Annemirl', 'Grupp', '1977-2-16', 'Lukas-Cranach-Straße', '71', '45257', 'Essen', '0201/61874213', 'annemirl_grupp@live-mail.none', 4473, 2556), (2, 'Fabian', 'Falkner', '1986-3-6', 'Friesenstraße', '72', '45889', 'Gelsenkirchen', '', 'fabian.falkner@web.none', 5082, 2904), (3, 'Eckehart', 'Schurr', '1909-10-18', 'Oberbergstraße', '63', '87600', 'Kaufbeuren', '08341/30605839', 'eckehart-schurr@open-mail.none', 1862, 1064), (4, 'Falk', 'Garz', '2014-11-7', 'Zum Heckelchen', '62', '37176', 'Nörten-Hardenberg', '05503/72030417', 'falkgarz@funmail.none', 4858, 2776), (5, 'Franzl', 'Blauth', '1949-7-18', 'Theißenstraße', '135', '78224', 'Singen', '07731/69296600', 'franzlblauth@hoster.none', 1750, 1000), (6, 'Sigbert', 'Reinisch', '1966-3-14', 'Sonnenhang', '173', '21398', 'Neetze', '05850/23452718', 'sigbert-reinisch@mymail.none', 3521, 2012), (7, 'Dietlinde', 'Pache', '1995-4-30', 'Hopfengarten', '118', '53533', 'Aremberg', '02691/59129425', 'd-pache@live-mail.none', 6818, 3896), (8, 'Denis', 'Katzmann', '1986-9-14', 'Auf der Oberau', '87a', '24214', 'Schinkel', '04346/6093627', '', 6895, 3940), (9, 'Dankfried', 'Höpfl', '1916-3-22', 'Sommerweg', '103', '56729', 'Lind', '02651/29558798', 'dankfried.hoepfl@justmail.none', 3941, 2252), (10, 'Lysann', 'Beßler', '1990-3-27', 'Epgerter Straße', '180', '25889', 'Witzwort', '04881/86773756', '', 5817, 3324), (11, 'Mattis', 'Halbritter', '1969-6-9', 'Ebbinghook', '47a', '56254', 'Müden', '02672/69115712', 'm_1969@quickmail.none', 3010, 1720), (12, 'Barbli', 'Graef', '1931-8-24', 'Im Brünnlislehen', '15', '79685', 'Häg-Ehrsberg', '07625/54583574', 'barbli-31@email.none', 2688, 1536), (13, 'Annerike', 'Rang', '2008-8-16', 'Viktoriastraße', '98', '54636', 'Niederweiler', '', '', 6419, 3668), (14, 'Dorothea', 'Kahl', '1947-9-1', 'Am Eichenkamp', '18', '57587', 'Birken-Honigsessen', '', 'd_kahl@open-mail.none', 6013, 3436), (15, 'Hildburga', 'Prieß', '1931-10-31', 'Kochstraße', '189b', '73337', 'Bad Überkingen', '07331/42791726', 'hildburga-priess@private.none', 5215, 2980), (16, 'Hanna', 'Holzhäuser', '1941-8-25', 'Holzwiesen', '47', '32609', 'Hüllhorst', '05744/53474470', 'h.holzhaeuser@retromail.none', 1456, 832), (17, 'Wedig', 'Päßler', '1987-10-30', 'Ackerstraße', '184', '56859', 'Bullay', '06542/98315755', 'wedigpaessler@net-mail.none', 4284, 2448), (18, 'Gunfried', 'Ziller', '2002-1-25', 'Alte Landstraße', '38', '72760', 'Reutlingen', '07121/14303972', 'g_ziller@company.none', 4459, 2548), (19, 'Theresa', 'Port', '2021-6-18', 'Amselstraße', '198', '79297', 'Winden', '07682/36214836', 'tport@funmail.none', 5145, 2940), (20, 'Kornelius', 'Heidemann', '2010-1-29', 'Bornplatz', '83', '76889', 'Schweigen-Rechtenbach', '06342/18574234', 'korneliusheidemann@xyz.none', 469, 268), (21, 'Curd', 'Ascher', '2012-2-16', 'Erdinger Straße', '47', '73265', 'Dettingen unter Teck', '', 'curd-ascher@kitty.none', 5355, 3060), (22, 'Hannetraud', 'Hübner', '2018-6-9', 'Stockhausener Straße', '152', '72519', 'Veringenstadt', '07577/11595401', 'hannetraudhuebner@web.none', 6622, 3784), (23, 'Sigolf', 'Luz', '1966-7-29', 'Schemmstraße', '23', '76761', 'Rülzheim', '07272/60469003', 'sigolf.1966@anymail.none', 945, 540), (24, 'Roselies', 'Weißenberger', '1982-12-13', 'Immenweg', '171', '24354', 'Kosel', '04354/14090482', 'roselies-weissenberger@goggle-mail.none', 5873, 3356), (25, 'Hannsjörg', 'Plöger', '1936-10-6', 'Am alten Garten', '92', '39307', 'Zabakuck', '03933/65748135', 'h.36@hoster.none', 1512, 864), (26, 'Ida', 'Both', '1926-8-19', 'Ammerländer Heerstraße', '163', '45257', 'Essen', '', 'ida1926@domain.none', 6013, 3436), (27, 'Genia', 'Meisinger', '1965-5-14', 'Begonienweg', '43', '45889', 'Gelsenkirchen', '0711/65980287', 'geniameisinger@ultramail.none', 6216, 3552), (28, 'Irmela', 'Krone', '2014-5-1', 'Im Kappesgarten', '143', '87600', 'Kaufbeuren', '02661/63503374', 'irmela-2014@funmail.none', 1813, 1036), (29, 'Engelbert', 'Eisenhardt', '1995-5-4', 'Schwanenstraße', '171', '37176', 'Nörten-Hardenberg', '08166/37157625', 'e.eisenhardt@bestmail.none', 1806, 1032), (30, 'Karlfried', 'Betz', '1925-10-5', 'Feuerhausstraße', '145', '78224', 'Singen', '08381/32967519', 'karlfried.25@inter-mail.none', 4382, 2504), (31, 'Wilbrandt', 'Kiefer', '1983-8-28', 'Neumarkt', '66', '21398', 'Neetze', '', 'wilbrandt_kiefer@inter-mail.none', 5978, 3416), (32, 'Marinette', 'Godau', '1967-11-2', 'Schweppermannstraße', '148', '53533', 'Aremberg', '', 'marinettegodau@funmail.none', 4802, 2744), (33, 'Urte', 'Bentz', '1912-4-1', 'Ibbenbürener Straße', '25', '24214', 'Schinkel', '08564/62774272', 'urte.bentz@justmail.none', 1071, 612), (34, 'Erdmute', 'Kämmerling', '1993-4-20', 'Haselstiege', '14', '56729', 'Lind', '08631/66342664', 'erdmute-kaemmerling@retromail.none', 1001, 572), (35, 'Elfi', 'Lackner', '1952-10-26', 'Neustadter Straße', '32', '25889', 'Witzwort', '05532/76100223', '', 3605, 2060), (36, 'Emely', 'Jörg', '1948-6-6', 'Jagdweg', '146', '56254', 'Müden', '06347/12584199', 'emelyjoerg@anymail.none', 1001, 572), (37, 'Evelyne', 'Ober', '2012-3-15', 'Bussardstraße', '131', '79685', 'Häg-Ehrsberg', '06761/14479709', 'evelyneober@private.none', 3969, 2268), (38, 'Ferfried', 'Zollner', '1905-12-10', 'Pilgerstraße', '57', '54636', 'Niederweiler', '06670/86320739', 'ferfried.zollner@hoster.none', 2107, 1204), (39, 'Cordian', 'Bilger', '1908-5-9', 'Hanfgarten', '126', '57587', 'Birken-Honigsessen', '07265/33511866', 'cordian_bilger@validmail.none', 5684, 3248), (40, 'Andrea', 'Deppisch', '2005-6-12', 'Zeller Straße', '116', '73337', 'Bad Überkingen', '04892/47291705', 'andrea.2005@domain.none', 189, 108), (41, 'Reinholdine', 'Rudert', '1936-5-10', 'Taunusstraße', '134', '32609', 'Hüllhorst', '06391/49094800', 'reinholdine_36@private.none', 133, 76), (42, 'Rotraud', 'Molitor', '1969-2-27', 'Kesseler Straße', '107', '56859', 'Bullay', '06731/89629727', '', 588, 336), (43, 'Iselore', 'Möhrle', '1978-12-21', 'Landgrafenstraße', '82', '72760', 'Reutlingen', '04131/6615818', 'iselore.moehrle@trashmail.none', 2891, 1652), (44, 'Alena', 'Pies', '1999-12-1', 'Am Wasserstollen', '139', '79297', 'Winden', '0211/31018906', 'alena.pies@ultramail.none', 5593, 3196), (45, 'Jessika', 'Wachholz', '1978-9-12', 'Eulenbergstraße', '39', '76889', 'Schweigen-Rechtenbach', '0681/98599050', 'jwachholz@email.none', 4158, 2376), (46, 'Meik', 'Weitzel', '1931-5-7', 'Im Münchfeld', '154', '73265', 'Dettingen unter Teck', '02604/15239252', 'meik.weitzel@goggle-mail.none', 4704, 2688), (47, 'Lars', 'Flöter', '1979-12-30', 'Pfarrer-Hansen-Straße', '103', '72519', 'Veringenstadt', '069/33164328', '', 2128, 1216), (48, 'Jamie', 'Reiners', '2020-1-23', 'Am Stübel', '104', '76761', 'Rülzheim', '', 'j20@private.none', 6615, 3780), (49, 'Ula', 'Mittermaier', '2017-9-1', 'Severinstraße', '45', '24354', 'Kosel', '', 'umittermaier@live-mail.none', 231, 132), (50, 'Eckfried', 'Handke', '1918-10-3', 'Haaner Straße', '98', '39307', 'Zabakuck', '04266/50518714', 'e.18@net-mail.none', 2051, 1172), (51, 'Theodeline', 'Pfingsten', '1935-6-21', 'Zum Steimel', '133', '45257', 'Essen', '09161/81194583', 'theodeline_pfingsten@net-mail.none', 3122, 1784);
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear