{"id":178088,"date":"2023-06-10T19:44:54","date_gmt":"2023-06-10T18:44:54","guid":{"rendered":"https:\/\/datascientest.com\/de\/?p=178088"},"modified":"2023-10-30T11:28:45","modified_gmt":"2023-10-30T10:28:45","slug":"insert-into-sql-so-kannst-du-daten-einfuegen","status":"publish","type":"post","link":"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen","title":{"rendered":"INSERT INTO SQL: So kannst du Daten einf\u00fcgen"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178088\" class=\"elementor elementor-178088\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3023e02 e-flex e-con-boxed e-con\" data-id=\"3023e02\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-884cea8 elementor-widget elementor-widget-heading\" data-id=\"884cea8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Um Daten innerhalb deiner SQL-Tabelle einzuf\u00fcgen, kannst du die INSERT INTO-Abfrage verwenden. Aber wie funktioniert das dann? Das werden wir uns in diesem Artikel ansehen.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fccc6db e-flex e-con-boxed e-con\" data-id=\"fccc6db\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d0c8f7b elementor-widget elementor-widget-heading\" data-id=\"d0c8f7b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Was ist die INSERT INTO-Abfrage?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-adfc2c6 elementor-widget elementor-widget-text-editor\" data-id=\"adfc2c6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"text-decoration: underline;\">INSERT INTO SQL\u00a0<\/span> ist einer der am h\u00e4ufigsten verwendeten Befehle in der <a href=\"https:\/\/datascientest.com\/de\/sql-update-daten-mit-diesem-befehl-aktualisieren\">SQL-Sprache<\/a>. Und das aus gutem Grund, denn mit dieser Abfrage kannst du neue Datens\u00e4tze in deine Datenbank einf\u00fcgen. Je nach Bedarf kann es sich dabei um eine oder mehrere Zeilen handeln.<\/p><p><span style=\"text-decoration: underline;\">Gut zu wissen:<\/span> <strong>INSERT INTO SQL<\/strong> ist der Befehl, den du f\u00fcr alle Datenbankverwaltungssysteme verwenden solltest. Und zwar unabh\u00e4ngig davon, ob du <a href=\"https:\/\/datascientest.com\/de\/wer-ist-oracle-der-groesste-herausforderer-von-azure-aws-und-google-cloud\">Oracle,<\/a> Mysql, Transact-SQL usw. benutzt.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Auch interessant:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"><colgroup><col width=\"268\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;MySQL Relationale Datenbanksoftware&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/mysql-eine-relationale-datenverwaltungssoftware\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/mysql-eine-relationale-datenverwaltungssoftware\" target=\"_blank\" rel=\"noopener\">MySQL Relationale Datenbanksoftware<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/sql-tutorial\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/sql-tutorial\" target=\"_blank\" rel=\"noopener\">SQL Tutorial<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Apache Cassandra noSQL BDD&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/apache-cassandra-die-beliebteste-nosql-bdd\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/apache-cassandra-die-beliebteste-nosql-bdd\" target=\"_blank\" rel=\"noopener\">Apache Cassandra noSQL BDD<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Joins&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/alles-uber-sql-joins-verstehen\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/alles-uber-sql-joins-verstehen\" target=\"_blank\" rel=\"noopener\">SQL Joins<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Count Tutorial&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/de\/sql-count-unser-tutorial\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/de\/sql-count-unser-tutorial\" target=\"_blank\" rel=\"noopener\">SQL Count Tutorial<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6733cda e-flex e-con-boxed e-con\" data-id=\"6733cda\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8ebe152 elementor-widget elementor-widget-heading\" data-id=\"8ebe152\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Wie verwendet man die Abfrage INSERT INTO SQL?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9ad66ff elementor-widget elementor-widget-text-editor\" data-id=\"9ad66ff\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>INSERT INTO SQL kann verwendet werden, um eine oder mehrere Zeilen in deine Tabelle einzuf\u00fcgen. Es ist aber auch m\u00f6glich, diesen Befehl in komplexeren Abfragen zu verwenden. In diesem Artikel stellen wir dir verschiedene Anwendungsf\u00e4lle vor.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-741dedb elementor-widget elementor-widget-heading\" data-id=\"741dedb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Eine Zeile einf\u00fcgen<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d2f0606 elementor-widget elementor-widget-text-editor\" data-id=\"d2f0606\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Hierf\u00fcr stehen dir zwei M\u00f6glichkeiten zur Verf\u00fcgung.<\/p><p>1\u00ba Es ist m\u00f6glich, eine Zeile einzuf\u00fcgen und dabei alle Spalten anzugeben. In diesem Fall lautet die Syntax wie folgt:<\/p><p><strong>INSERT INTO table VALUES (&#8218;Wert 1&#8216;, &#8218;Wert 2&#8216;, &#8230;)<\/strong><\/p><p>Wenn du diese Option w\u00e4hlst, achte darauf, dass du die Reihenfolge der Spalten einh\u00e4ltst. Das Datenbankverwaltungssystem interpretiert die SQL-Abfragen entsprechend der Informationen, die du ihm gibst. Wenn du also keine neuen Werte f\u00fcr bestimmte Spalten speichern willst, musst du &#8222;NULL&#8220; angeben (anstelle von Wert 1, 2, &#8230;).<\/p><p>Der Vorteil ist, dass du nicht den Namen jeder Grenze schreiben musst. Dies schr\u00e4nkt Tippfehler stark ein.<\/p><p>2\u00ba Du kannst nur die Spalten angeben, f\u00fcr die du neue Daten integrieren willst. Dazu musst du die folgende Syntax verwenden:<\/p><p>INSERT INTO table (spaltenname_1, spaltenname_2, &#8230;)<br \/>VALUES (&#8218;Wert 1&#8216;, &#8218;Wert 2&#8216;, &#8230;)<\/p><p>Hier ist die Reihenfolge der Spalten nicht mehr so wichtig. Achte jedoch auf die Reihenfolge der Werte. Die Werte m\u00fcssen mit den Spalten \u00fcbereinstimmen, denen sie zugewiesen sind.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b912e6c elementor-widget elementor-widget-heading\" data-id=\"b912e6c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Mehrere Zeilen einf\u00fcgen<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b64bcfa elementor-widget elementor-widget-text-editor\" data-id=\"b64bcfa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Das Einf\u00fcgen mehrerer Zeilen ist oft notwendig, um deine Tabelle zu erweitern.<\/p><p>Um das besser zu verstehen, zeigen wir dir das konkrete Beispiel einer Kundendatei, der du die Kontaktdaten mehrerer Kunden hinzuf\u00fcgen m\u00f6chtest.<\/p><p>Hier ist die Abfrage:<\/p><p>INSERT INTO Kunde (Vorname, Nachname, Ort, E-Mail).<br \/>VALUES<br \/>(&#8218;Justine&#8216;, &#8218;Martin&#8216;, &#8218;Paris&#8216;, &#8218;justinemartin@gmail.com&#8216; ),<br \/>(&#8218;Thomas&#8216;, &#8218;Durant&#8216;, &#8218;Bordeaux&#8216;, &#8218;tomtom@sfr.fr&#8216;),<br \/>(&#8218;Marie&#8216;, &#8218;Leroy&#8216;, &#8218;Angers&#8216;, &#8218;marieleroy@laposte.net&#8216;),<br \/>(&#8218;Vanessa&#8216;, &#8218;Savary&#8216;, &#8218;Marseille&#8216;, &#8218;vanessa13@gmail.com&#8216;)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ce2308 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1ce2308\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/de\/unsere-aus-und-weiterbildungen\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Mehr \u00fcber INSERT INTO SQL lernen<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3616be5 elementor-widget elementor-widget-text-editor\" data-id=\"3616be5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Mit dem Befehl INSERT INTO SQL kannst du die folgenden Daten in deine Tabelle einf\u00fcgen.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-59fd461 elementor-widget elementor-widget-html\" data-id=\"59fd461\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Name<\/th>\r\n    <th class=\"tg-8806\">Stadt<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Thomas <\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-baqh\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Marie<\/td>\r\n    <td class=\"tg-baqh\">Leroy<\/td>\r\n    <td class=\"tg-baqh\">Angers<\/td>\r\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Vanessa<\/td>\r\n    <td class=\"tg-baqh\">Savary<\/td>\r\n    <td class=\"tg-baqh\">Marseille<\/td>\r\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e9708c elementor-widget elementor-widget-heading\" data-id=\"4e9708c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Daten aus einer anderen Tabelle kopieren<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f1dce80 elementor-widget elementor-widget-text-editor\" data-id=\"f1dce80\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Wenn du mehrere Abfragen kombinierst, kannst du auch Daten aus Array A in ein Array kopieren.<\/p><p>Dazu musst du die folgende Syntax verwenden:<\/p><p>INSERT INTO ma_table_1 SELECT column_1,column_2,column_2 FROM ma_table_2 WHERE conditions.<\/p><p>Nehmen wir ein Beispiel:<\/p><p>Du hast zwei Tabellen. Die erste entspricht einer &#8222;Kunden&#8220;-Datei:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e3b5c1 elementor-widget elementor-widget-html\" data-id=\"7e3b5c1\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Nachname<\/th>\r\n    <th class=\"tg-8806\">Stadt<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Thomas <\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-baqh\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Marie<\/td>\r\n    <td class=\"tg-baqh\">Leroy<\/td>\r\n    <td class=\"tg-baqh\">Angers<\/td>\r\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Vanessa<\/td>\r\n    <td class=\"tg-baqh\">Savary<\/td>\r\n    <td class=\"tg-baqh\">Marseille<\/td>\r\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93a949f elementor-widget elementor-widget-text-editor\" data-id=\"93a949f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Und eine zweite Sales-Tabelle:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a1471b elementor-widget elementor-widget-html\" data-id=\"2a1471b\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 525px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">ID<\/th>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Nachname<\/th>\r\n    <th class=\"tg-8806\">Stadt<\/th>\r\n    <th class=\"tg-8806\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-8806\">1<\/td>\r\n    <td class=\"tg-c3ow\">Jean<\/td>\r\n    <td class=\"tg-c3ow\">Bernad<\/td>\r\n    <td class=\"tg-c3ow\">Valenciennes<\/td>\r\n    <td class=\"tg-c3ow\">jbernard@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-8806\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas <\/td>\r\n    <td class=\"tg-c3ow\">Castaing<\/td>\r\n    <td class=\"tg-c3ow\">Nantes<\/td>\r\n    <td class=\"tg-c3ow\">thomas.castaing@orange.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-8806\">3<\/td>\r\n    <td class=\"tg-c3ow\">Antoine<\/td>\r\n    <td class=\"tg-c3ow\">Dupond<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-c3ow\">Antwan@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-8806\">4<\/td>\r\n    <td class=\"tg-c3ow\">Virginie<\/td>\r\n    <td class=\"tg-c3ow\">Pavard<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">V.pavard@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a14893 elementor-widget elementor-widget-text-editor\" data-id=\"9a14893\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Nachdem du einen Interessenten (Jean Bernard) konvertiert hast, m\u00f6chtest du ihn in deine Kundendatei \u00fcbertragen.<\/p><p>Hier ist die Abfrage:<\/p><p>INSERT INTO Kunde SELECT (Vorname, Nachname, Stadt, E-Mail) FROM prospect WHERE id = 1.<\/p><p>Und das Ergebnis:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8b045b9 elementor-widget elementor-widget-html\" data-id=\"8b045b9\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Vorname<\/th>\r\n    <th class=\"tg-8806\">Nachname<\/th>\r\n    <th class=\"tg-8806\">Stadt<\/th>\r\n    <th class=\"tg-8806\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-c3ow\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Thomas <\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n    <td class=\"tg-c3ow\">Angers<\/td>\r\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Vanessa<\/td>\r\n    <td class=\"tg-c3ow\">Savary<\/td>\r\n    <td class=\"tg-c3ow\">Marseille<\/td>\r\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Jean<\/td>\r\n    <td class=\"tg-baqh\">Bernard<\/td>\r\n    <td class=\"tg-baqh\">Valenciennes<\/td>\r\n    <td class=\"tg-baqh\">jbernard@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ede0fb2 e-flex e-con-boxed e-con\" data-id=\"ede0fb2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b9191e4 elementor-widget elementor-widget-heading\" data-id=\"b9191e4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Erweitere deine SQL-Sprachenkenntnisse mit DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-870e9bb elementor-widget elementor-widget-text-editor\" data-id=\"870e9bb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Die Arbeit mit <a href=\"https:\/\/datascientest.com\/de\/relationale-datenbanken\">relationalen Daten<\/a> besteht nicht nur darin, neue Informationen hinzuzuf\u00fcgen. Es ist auch m\u00f6glich, Daten zu l\u00f6schen, zu \u00e4ndern, zu aktualisieren etc. F\u00fcr all diese Aktionen gibt es eine Vielzahl von <strong>SQL-Abfragen.<\/strong><\/p><p>Wenn du sie alle kennenlernen m\u00f6chtest, ist eine Datenschulung mehr als notwendig. Genau aus diesem Grund haben wir DataScientest entwickelt. Wir bieten dir verschiedene berufsorientierte Schulungen an, um dir zu helfen, deine F\u00e4higkeiten zu erweitern.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a9e951b elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a9e951b\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/de\/unsere-aus-und-weiterbildungen\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Entdecke die DataScientest Weiterbildungen<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1a6c9fc elementor-widget elementor-widget-html\" data-id=\"1a6c9fc\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">.\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{{\n    \"@type\": \"Frage\",\n    \"name\": \"Was ist UPDATE SQL?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Der SQL-Befehl UPDATE wird verwendet, um Daten in einer Tabelle zu aktualisieren. Dies ist notwendig, wenn du eine Datenbank mit aktuellen und zuverl\u00e4ssigen Informationen haben m\u00f6chtest. Da die Datenqualit\u00e4t eine der gr\u00f6\u00dften Herausforderungen f\u00fcr Datenexperten ist, ist UPDATE eine der h\u00e4ufigsten SQL-Anfragen.\"\n    }\n  },{\n    \"@type\": \"Frage\",\n    \"name\": \"Wie verwende ich den SQL-Befehl UPDATE?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Um sie besser zu verstehen, sollten wir auf ihre wichtigsten Attribute eingehen, n\u00e4mlich: : Die SET-Klausel: Hiermit kannst du festlegen, durch was du die vorhandenen Daten ersetzen willst. Hier m\u00fcssen nur die Spalten angegeben werden, die ge\u00e4ndert werden sollen. Alle anderen behalten ihre aktuellen Werte bei. Die WHERE-Klausel: Damit legst du fest, wo sich die \u00c4nderungen beziehen.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Um Daten innerhalb deiner SQL-Tabelle einzuf\u00fcgen, kannst du die INSERT INTO-Abfrage verwenden. Aber wie funktioniert das dann? Das werden wir uns in diesem Artikel ansehen. Was ist die INSERT INTO-Abfrage? INSERT INTO SQL&nbsp; ist einer der am h\u00e4ufigsten verwendeten Befehle in der SQL-Sprache. Und das aus gutem Grund, denn mit dieser Abfrage kannst du neue [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":178089,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2454],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>INSERT INTO SQL: So kannst du Daten einf\u00fcgen<\/title>\n<meta name=\"description\" content=\"Die SQL-Anweisung INSERT INTO wird verwendet, um Daten in eine Tabelle einer Datenbank einzuf\u00fcgen. Viele wissen allerdings nicht, dass ...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"INSERT INTO SQL: So kannst du Daten einf\u00fcgen\" \/>\n<meta property=\"og:description\" content=\"Um Daten innerhalb deiner SQL-Tabelle einzuf\u00fcgen, kannst du die INSERT INTO-Abfrage verwenden. Aber wie funktioniert das dann? Das werden wir uns in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen\" \/>\n<meta property=\"og:site_name\" content=\"Weiterbildung Data Science | DataScientest.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-10T18:44:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-30T10:28:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2023\/06\/sql-insert-into-datascientest.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"INSERT INTO SQL: So kannst du Daten einf\u00fcgen\",\"datePublished\":\"2023-06-10T18:44:54+00:00\",\"dateModified\":\"2023-10-30T10:28:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen\"},\"wordCount\":745,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/de\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen\",\"url\":\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen\",\"name\":\"INSERT INTO SQL: So kannst du Daten einf\u00fcgen\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/de\/#website\"},\"datePublished\":\"2023-06-10T18:44:54+00:00\",\"dateModified\":\"2023-10-30T10:28:45+00:00\",\"description\":\"Die SQL-Anweisung INSERT INTO wird verwendet, um Daten in eine Tabelle einer Datenbank einzuf\u00fcgen. Viele wissen allerdings nicht, dass ...\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/de\/#website\",\"url\":\"https:\/\/datascientest.com\/de\/\",\"name\":\"Weiterbildung Data Science | DataScientest.com\",\"description\":\"F\u00fchrender Anbieter von Schulungen im Bereich Data Science\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/de\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/company\/datascientest-germany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/datascientest.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/de\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"INSERT INTO SQL: So kannst du Daten einf\u00fcgen","description":"Die SQL-Anweisung INSERT INTO wird verwendet, um Daten in eine Tabelle einer Datenbank einzuf\u00fcgen. Viele wissen allerdings nicht, dass ...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen","og_locale":"de_DE","og_type":"article","og_title":"INSERT INTO SQL: So kannst du Daten einf\u00fcgen","og_description":"Um Daten innerhalb deiner SQL-Tabelle einzuf\u00fcgen, kannst du die INSERT INTO-Abfrage verwenden. Aber wie funktioniert das dann? Das werden wir uns in","og_url":"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen","og_site_name":"Weiterbildung Data Science | DataScientest.com","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-06-10T18:44:54+00:00","article_modified_time":"2023-10-30T10:28:45+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2023\/06\/sql-insert-into-datascientest.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Verfasst von":"Melanie","Gesch\u00e4tzte Lesezeit":"4 Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen#article","isPartOf":{"@id":"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"INSERT INTO SQL: So kannst du Daten einf\u00fcgen","datePublished":"2023-06-10T18:44:54+00:00","dateModified":"2023-10-30T10:28:45+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen"},"wordCount":745,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/de\/#organization"},"articleSection":["Data Science"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen","url":"https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen","name":"INSERT INTO SQL: So kannst du Daten einf\u00fcgen","isPartOf":{"@id":"https:\/\/datascientest.com\/de\/#website"},"datePublished":"2023-06-10T18:44:54+00:00","dateModified":"2023-10-30T10:28:45+00:00","description":"Die SQL-Anweisung INSERT INTO wird verwendet, um Daten in eine Tabelle einer Datenbank einzuf\u00fcgen. Viele wissen allerdings nicht, dass ...","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/de\/insert-into-sql-so-kannst-du-daten-einfuegen"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/de\/#website","url":"https:\/\/datascientest.com\/de\/","name":"Weiterbildung Data Science | DataScientest.com","description":"F\u00fchrender Anbieter von Schulungen im Bereich Data Science","publisher":{"@id":"https:\/\/datascientest.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/de\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/de\/wp-content\/blogs.dir\/8\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/company\/datascientest-germany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/datascientest.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/de\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts\/178088"}],"collection":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/comments?post=178088"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/posts\/178088\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/media\/178089"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/media?parent=178088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/categories?post=178088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/de\/wp-json\/wp\/v2\/tags?post=178088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}