{"id":2523,"date":"2021-07-21T07:47:43","date_gmt":"2021-07-21T05:47:43","guid":{"rendered":"https:\/\/www.ewig-drohendes-versagen.de\/?p=2523"},"modified":"2021-07-21T07:48:43","modified_gmt":"2021-07-21T05:48:43","slug":"import-timezone-in-mariadb-unter-windows","status":"publish","type":"post","link":"https:\/\/www.ewig-drohendes-versagen.de\/?p=2523","title":{"rendered":"Import TimeZone in MariaDB unter Windows"},"content":{"rendered":"\n\n\n

F\u00fcr den Import werden Zeitzonen Tabellen ben\u00f6tigt welche man hier: https:\/\/dev.mysql.com\/downloads\/timezones.html<\/a> bekommt.<\/p>\n\n\n\n


Diese k\u00f6nnen dann z.B. mit Heidi oder per Console eingespielt werden.<\/p>\n\n\n\n


Problem ist allerdings, dass eine der Spalten „Offset“ hei\u00dft und dies eins der SQL Keyword ist….<\/p>\n\n\n\n

Abhilfe schafft ein Suchen nach Offset, und ein Ersetzten mit `Offset` – wichtig die richtigen Anf\u00fchrungszeichen hier zu verwenden.<\/p>\n\n\n\n

\"\"<\/a>
Original<\/figcaption><\/figure>\n\n\n\n
\"\"<\/a>
Funktional<\/figcaption><\/figure>\n\n\n\n

@Google
How to deal with SQL column names that look like SQL keywords?
mariadb offset as colum name
mariadb timezone offset
import timezone in mariadb under windows
<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"

F\u00fcr den Import werden Zeitzonen Tabellen ben\u00f6tigt welche man hier: https:\/\/dev.mysql.com\/downloads\/timezones.html bekommt. Diese k\u00f6nnen dann z.B. mit Heidi oder per Console eingespielt werden. Problem ist allerdings, dass eine der Spalten „Offset“ hei\u00dft und dies eins der SQL Keyword ist…. Abhilfe schafft ein Suchen nach Offset, und ein Ersetzten mit `Offset` – wichtig die richtigen Anf\u00fchrungszeichen […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[16],"tags":[76,26,71],"class_list":["post-2523","post","type-post","status-publish","format-standard","hentry","category-edv-probleme","tag-mariadb","tag-windows","tag-work"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/peux2-EH","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/posts\/2523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2523"}],"version-history":[{"count":4,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/posts\/2523\/revisions"}],"predecessor-version":[{"id":2529,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/posts\/2523\/revisions\/2529"}],"wp:attachment":[{"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}