{"id":108,"date":"2021-10-04T13:49:48","date_gmt":"2021-10-04T13:49:48","guid":{"rendered":"https:\/\/christoph-schmalfuss.de\/blog\/?p=108"},"modified":"2021-10-22T11:06:31","modified_gmt":"2021-10-22T11:06:31","slug":"python-mysql-daten-aendern","status":"publish","type":"post","link":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/","title":{"rendered":"Python MySQL Daten \u00e4ndern"},"content":{"rendered":"\n<p>Hinweis: <a href=\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/08\/12\/python-mysql-daten-einfuegen-tutorial-deutsch-fuer-anfaengerinnen-und-anfaenger-%f0%9f%90%ac\/\">Hier<\/a> findest du einen weiteren Artikel zum Thema MySQL, den du idealerweise vorher gelesen hast.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/youtu.be\/2YhGjO_F1Ls\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu-1024x576.png\" alt=\"\" class=\"wp-image-83\" srcset=\"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu-1024x576.png 1024w, https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu-300x169.png 300w, https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu-768x432.png 768w, https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>In diesem Artikel schauen wir uns an, wie man mit Python Daten in einer MySQL-Datenbank \u00e4ndern kann. Viel Spa\u00df!<\/p>\n\n\n\n<p>Der SQL-Befehl, um einen Datensatz zu \u00e4ndern, besteht grunds\u00e4tzlich aus drei Teilen. <\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>UPDATE konzerte\nSET stadt = &#39;Akkon&#39;\nWHERE stadt = &#39;Haifa&#39;<\/code><\/pre><\/div>\n\n\n\n<p>Am Anfang steht der Befehl UPDATE und der Name der Tabelle, in der wir arbeiten. In unserem Beispiel hei\u00dft die Tabelle konzerte.<\/p>\n\n\n\n<p>Als n\u00e4chstes folgt der SET-Befehl. Mit diesem setzen wir einen neuen Wert in die Tabelle ein und \u00fcberschreiben damit den alten Wert.<\/p>\n\n\n\n<p>Und mit dem WHERE-Befehl legen wir fest, welche Bedingung erf\u00fcllt sein muss. Hier habe ich festgelegt, dass der Datensatz \u00fcberschrieben wird, bei dem die Stadt Haifa eingetragen ist. <\/p>\n\n\n\n<p>Wir k\u00f6nnen das ja mal mit Python ausprobieren. Den alten Befehl vom letzten Mal l\u00f6schen wir erstmal raus. <\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code># insert_concert_from_user_input()<\/code><\/pre><\/div>\n\n\n\n<p>Jetzt k\u00f6nnen wir den SQL-Befehl festlegen. Den m\u00fcssen wir dann nur noch ausf\u00fchren und best\u00e4tigen.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code>sql = &#39;UPDATE konzerte SET stadt = &quot;M\u00fcnchen&quot; WHERE stadt = &quot;Akkon&quot;&#39; # Befehl festlegen\nmy_cursor.execute(sql) # ausf\u00fchren\nmy_db.commit() # best\u00e4tigen<\/code><\/pre><\/div>\n\n\n\n<p>Es ist aber nat\u00fcrlich bisschen bl\u00f6d, wenn wir f\u00fcr jede \u00c4nderung in der Datenbank unseren Quellcode anpassen. Deshalb macht es Sinn, eine Funktion zu schreiben, die dem Nutzer diese Arbeit erspart. Ich zeig euch mal an einem Beispiel, wie so eine Funktion aussehen k\u00f6nnte. <\/p>\n\n\n\n<p>Wir schreiben einen kleinen Dialog f\u00fcr den Nutzer, der nach der alten Stadt fragt, die ersetzt werden soll und nach der neuen Stadt fragt, die eingef\u00fcgt werden soll:<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code>def update_city():\n    old_city = input(&#39;Welche Stadt soll ersetzt werden? &#39;)\n    new_city = input(&#39;Welche Stadt soll stattdessen eingetragen werden? &#39;)\n<\/code><\/pre><\/div>\n\n\n\n<p>Aus diesen Eingaben bauen wir jetzt einen SQL-Befehl. Auch den f\u00fchren wir wieder aus und best\u00e4tigen ihn.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code>    sql = f&#39;UPDATE konzerte SET stadt = &quot;{new_city}&quot; WHERE stadt = &quot;{old_city}&quot;&#39;\n    my_cursor.execute(sql)\n    my_db.commit()<\/code><\/pre><\/div>\n\n\n\n<p>Anschlie\u00dfend rufen wir die Funktion auf.<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code>update_city():<\/code><\/pre><\/div>\n\n\n\n<p>Wenn wir das Skript jetzt ausf\u00fchren, sollte das eigentlich alles schon gut funktionieren. Probieren wir es aus!<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>Welche Stadt soll ersetzt werden? Haifa\nWelche Stadt soll stattdessen eingetragen werden? D\u00f6beln\n(datetime.date(2017, 11, 11), &#39;Israel&#39;, &#39;D\u00f6beln&#39;)\n(datetime.date(2017, 11, 10), &#39;Israel&#39;, &#39;Tel Aviv&#39;)\n\nProcess finished with exit code 0<\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u2705 Kompletter Quellcode<\/h2>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-python\" data-lang=\"Python\"><code>import mysql.connector\n\nmy_db = mysql.connector.connect(\n    host=&quot;localhost&quot;,\n    user=&quot;root&quot;,\n    password=&quot;adsfwioern95203740\u00df!!?=234yxn\u00fccasd..er!&quot;,\n    database=&quot;tourplaner&quot;\n)\n\nmy_cursor = my_db.cursor()\n\n\ndef insert_concert_from_user_input():\n\n    datum = input(&#39;Datum: &#39;)\n    land = input(&#39;Land: &#39;)\n    stadt = input(&#39;Stadt: &#39;)\n\n    val = f&#39;&quot;{datum}&quot;, &quot;{land}&quot;, &quot;{stadt}&#39;\n    sql = f&#39;INSERT INTO konzerte VALUE ({val})&#39;\n\n    my_cursor.execute(sql)\n    my_db.commit()\n\n\ndef show_all_data():\n    my_cursor.execute(&quot;SELECT * FROM konzerte&quot;)\n    result = my_cursor.fetchall()\n\n    for _ in result:\n        print(_)\n\n\ndef update_city():\n    old_city = input(&#39;Welche Stadt soll ersetzt werden? &#39;)\n    new_city = input(&#39;Welche Stadt soll stattdessen eingetragen werden? &#39;)\n\n    sql = f&#39;UPDATE konzerte SET stadt = &quot;{new_city}&quot; WHERE stadt = &quot;{old_city}&quot;&#39;\n    my_cursor.execute(sql)\n    my_db.commit()\n\n\nupdate_city()\nshow_all_data()<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hinweis: Hier findest du einen weiteren Artikel zum Thema MySQL, den du idealerweise vorher gelesen hast. In diesem Artikel schauen&hellip;<\/p>\n","protected":false},"author":1,"featured_media":83,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-108","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-datenbanken"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python MySQL Daten \u00e4ndern &mdash; Programmieren mit Chris<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python MySQL Daten \u00e4ndern &mdash; Programmieren mit Chris\" \/>\n<meta property=\"og:description\" content=\"Hinweis: Hier findest du einen weiteren Artikel zum Thema MySQL, den du idealerweise vorher gelesen hast. In diesem Artikel schauen&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/\" \/>\n<meta property=\"og:site_name\" content=\"Programmieren mit Chris\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-04T13:49:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-22T11:06:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@chrischmayt\" \/>\n<meta name=\"twitter:site\" content=\"@chrischmayt\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"chris\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"3\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#organization\",\"name\":\"Programmieren mit Chris\",\"url\":\"https:\/\/christoph-schmalfuss.de\/blog\/\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/christoph-schmalfu\\u00df-52a93b209\/\",\"https:\/\/www.youtube.com\/channel\/UC0faHRYVxDn7chW573SSh8A\",\"https:\/\/twitter.com\/chrischmayt\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#logo\",\"inLanguage\":\"de\",\"url\":\"http:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/programmieren-mit-chris-logo-ohne-schatten-3000x3000-transparent.png\",\"contentUrl\":\"http:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/programmieren-mit-chris-logo-ohne-schatten-3000x3000-transparent.png\",\"width\":3000,\"height\":3000,\"caption\":\"Programmieren mit Chris\"},\"image\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#website\",\"url\":\"https:\/\/christoph-schmalfuss.de\/blog\/\",\"name\":\"Programmieren lernen mit Chris\",\"description\":\"Tutorials | Vlogs\",\"publisher\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/christoph-schmalfuss.de\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#primaryimage\",\"inLanguage\":\"de\",\"url\":\"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png\",\"contentUrl\":\"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png\",\"width\":1280,\"height\":720},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#webpage\",\"url\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/\",\"name\":\"Python MySQL Daten \\u00e4ndern &mdash; Programmieren mit Chris\",\"isPartOf\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#primaryimage\"},\"datePublished\":\"2021-10-04T13:49:48+00:00\",\"dateModified\":\"2021-10-22T11:06:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/christoph-schmalfuss.de\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python MySQL Daten \\u00e4ndern\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#webpage\"},\"author\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#\/schema\/person\/b64d7415ba9ac63f395509d7097012bb\"},\"headline\":\"Python MySQL Daten \\u00e4ndern\",\"datePublished\":\"2021-10-04T13:49:48+00:00\",\"dateModified\":\"2021-10-22T11:06:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#webpage\"},\"wordCount\":290,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png\",\"articleSection\":[\"Datenbanken\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#\/schema\/person\/b64d7415ba9ac63f395509d7097012bb\",\"name\":\"chris\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/christoph-schmalfuss.de\/blog\/#personlogo\",\"inLanguage\":\"de\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/176e906a49456dda30761449564e6e69d6b070f731880e6ace0d8e2d1746f1b6?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/176e906a49456dda30761449564e6e69d6b070f731880e6ace0d8e2d1746f1b6?s=96&d=retro&r=g\",\"caption\":\"chris\"},\"sameAs\":[\"http:\/\/christoph-schmalfuss.de\/blog\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Python MySQL Daten \u00e4ndern &mdash; Programmieren mit Chris","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:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/","og_locale":"de_DE","og_type":"article","og_title":"Python MySQL Daten \u00e4ndern &mdash; Programmieren mit Chris","og_description":"Hinweis: Hier findest du einen weiteren Artikel zum Thema MySQL, den du idealerweise vorher gelesen hast. In diesem Artikel schauen&hellip;","og_url":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/","og_site_name":"Programmieren mit Chris","article_published_time":"2021-10-04T13:49:48+00:00","article_modified_time":"2021-10-22T11:06:31+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png","path":"\/var\/www\/virtual\/schmalin\/html\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png","size":"full","id":83,"alt":"","pixels":921600,"type":"image\/png"}],"twitter_card":"summary_large_image","twitter_creator":"@chrischmayt","twitter_site":"@chrischmayt","twitter_misc":{"Verfasst von":"chris","Gesch\u00e4tzte Lesezeit":"3\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/christoph-schmalfuss.de\/blog\/#organization","name":"Programmieren mit Chris","url":"https:\/\/christoph-schmalfuss.de\/blog\/","sameAs":["https:\/\/www.linkedin.com\/in\/christoph-schmalfu\u00df-52a93b209\/","https:\/\/www.youtube.com\/channel\/UC0faHRYVxDn7chW573SSh8A","https:\/\/twitter.com\/chrischmayt"],"logo":{"@type":"ImageObject","@id":"https:\/\/christoph-schmalfuss.de\/blog\/#logo","inLanguage":"de","url":"http:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/programmieren-mit-chris-logo-ohne-schatten-3000x3000-transparent.png","contentUrl":"http:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/programmieren-mit-chris-logo-ohne-schatten-3000x3000-transparent.png","width":3000,"height":3000,"caption":"Programmieren mit Chris"},"image":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/#logo"}},{"@type":"WebSite","@id":"https:\/\/christoph-schmalfuss.de\/blog\/#website","url":"https:\/\/christoph-schmalfuss.de\/blog\/","name":"Programmieren lernen mit Chris","description":"Tutorials | Vlogs","publisher":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/christoph-schmalfuss.de\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"ImageObject","@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#primaryimage","inLanguage":"de","url":"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png","contentUrl":"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png","width":1280,"height":720},{"@type":"WebPage","@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#webpage","url":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/","name":"Python MySQL Daten \u00e4ndern &mdash; Programmieren mit Chris","isPartOf":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#primaryimage"},"datePublished":"2021-10-04T13:49:48+00:00","dateModified":"2021-10-22T11:06:31+00:00","breadcrumb":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/christoph-schmalfuss.de\/blog\/"},{"@type":"ListItem","position":2,"name":"Python MySQL Daten \u00e4ndern"}]},{"@type":"Article","@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#article","isPartOf":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#webpage"},"author":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/#\/schema\/person\/b64d7415ba9ac63f395509d7097012bb"},"headline":"Python MySQL Daten \u00e4ndern","datePublished":"2021-10-04T13:49:48+00:00","dateModified":"2021-10-22T11:06:31+00:00","mainEntityOfPage":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#webpage"},"wordCount":290,"commentCount":0,"publisher":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/#organization"},"image":{"@id":"https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#primaryimage"},"thumbnailUrl":"https:\/\/christoph-schmalfuss.de\/blog\/wp-content\/uploads\/2021\/08\/Thumbnail-sql-neu.png","articleSection":["Datenbanken"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/christoph-schmalfuss.de\/blog\/2021\/10\/04\/python-mysql-daten-aendern\/#respond"]}]},{"@type":"Person","@id":"https:\/\/christoph-schmalfuss.de\/blog\/#\/schema\/person\/b64d7415ba9ac63f395509d7097012bb","name":"chris","image":{"@type":"ImageObject","@id":"https:\/\/christoph-schmalfuss.de\/blog\/#personlogo","inLanguage":"de","url":"https:\/\/secure.gravatar.com\/avatar\/176e906a49456dda30761449564e6e69d6b070f731880e6ace0d8e2d1746f1b6?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/176e906a49456dda30761449564e6e69d6b070f731880e6ace0d8e2d1746f1b6?s=96&d=retro&r=g","caption":"chris"},"sameAs":["http:\/\/christoph-schmalfuss.de\/blog"]}]}},"_links":{"self":[{"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/posts\/108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/comments?post=108"}],"version-history":[{"count":10,"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/posts\/108\/revisions"}],"predecessor-version":[{"id":124,"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/posts\/108\/revisions\/124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/media\/83"}],"wp:attachment":[{"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/categories?post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/christoph-schmalfuss.de\/blog\/wp-json\/wp\/v2\/tags?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}