{"id":1121,"date":"2023-03-23T19:07:59","date_gmt":"2023-03-23T19:07:59","guid":{"rendered":"https:\/\/datacrow.org\/?post_type=docs&#038;p=1121"},"modified":"2023-03-23T19:08:00","modified_gmt":"2023-03-23T19:08:00","password":"","slug":"datenbank-editor","status":"publish","type":"docs","link":"https:\/\/datacrow.org\/de\/docs\/database-editor\/","title":{"rendered":"Datenbank-Editor"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><em>Men\u00fcpfad: Werkzeuge &gt; Datenbank-Editor<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Der Datenbank-Editor bietet eine schnelle und direkte M\u00f6glichkeit, die Daten in der Datenbank zu bearbeiten. Er setzt alle Datenpr\u00fcfungen au\u00dfer Kraft und sollte daher mit Vorsicht behandelt werden.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-49.png\" alt=\"\" class=\"wp-image-1122\" width=\"684\" height=\"510\" srcset=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-49.png 845w, https:\/\/datacrow.org\/wp-content\/uploads\/image-49-300x224.png 300w, https:\/\/datacrow.org\/wp-content\/uploads\/image-49-768x573.png 768w\" sizes=\"(max-width: 684px) 100vw, 684px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Wenn Sie mit SQL nicht vertraut sind, sollten Sie den Datenbank-Editor besser nicht verwenden, da Sie unerw\u00fcnschte \u00c4nderungen vornehmen k\u00f6nnten.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sie m\u00fcssen sich auch mit der Syntax von <a href=\"https:\/\/hsqldb.org\/doc\/guide\/\">HSQL DB<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Erstellen und Ausf\u00fchren einer SQL-Anweisung<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Geben Sie eine SQL-Anweisung in das Feld \"Abfrageeingabe\" ein und dr\u00fccken Sie auf \"Ausf\u00fchren\", um die Anweisung auszuf\u00fchren. Wenn die Abfrage nicht korrekt war, werden Fehler angezeigt (diese Meldungen werden nicht von Data Crow, sondern von der Datenbank-Engine erzeugt).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Zuvor ausgef\u00fchrte Anweisungen k\u00f6nnen \u00fcber das Listenfeld \"Gespeicherte SQL-Anweisungen\" abgerufen werden.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"844\" height=\"71\" src=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-51.png\" alt=\"\" class=\"wp-image-1124\" srcset=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-51.png 844w, https:\/\/datacrow.org\/wp-content\/uploads\/image-51-300x25.png 300w, https:\/\/datacrow.org\/wp-content\/uploads\/image-51-768x65.png 768w\" sizes=\"(max-width: 844px) 100vw, 844px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Das Ergebnis einer Select-Abfrage wird in der Tabelle \"Abfrageergebnis\" angezeigt.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"851\" height=\"249\" src=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-50.png\" alt=\"\" class=\"wp-image-1123\" srcset=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-50.png 851w, https:\/\/datacrow.org\/wp-content\/uploads\/image-50-300x88.png 300w, https:\/\/datacrow.org\/wp-content\/uploads\/image-50-768x225.png 768w\" sizes=\"(max-width: 851px) 100vw, 851px\" \/><\/figure>","protected":false},"excerpt":{"rendered":"<p>Men\u00fcpfad: Werkzeuge &gt; Datenbank-Editor Der Datenbank-Editor bietet eine schnelle und direkte M\u00f6glichkeit, die Daten in der Datenbank zu bearbeiten. Er setzt alle Pr\u00fcfungen au\u00dfer Kraft...<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_seopress_news_disabled":"","_seopress_video_disabled":"","_seopress_video":[],"_seopress_pro_schemas_manual":[],"_seopress_pro_rich_snippets_disable_all":"","_seopress_pro_rich_snippets_disable":[],"_seopress_pro_schemas":[],"_eb_attr":"","_customify_content_layout":"","_customify_sidebar":"","_customify_page_header_display":"default","_customify_disable_header":"","_customify_disable_header_top":"","_customify_disable_header_main":"","_customify_disable_header_bottom":"","_customify_disable_page_title":"","_customify_disable_content_vertical_padding":"","_customify_disable_footer_top":"","_customify_disable_footer_main":"","_customify_disable_footer_bottom":"","_customify_breadcrumb_display":"default","_customify_header_transparent_display":"","footnotes":""},"doc_category":[19],"doc_tag":[],"class_list":["post-1121","docs","type-docs","status-publish","hentry","doc_category-system-tools"],"year_month":"2026-09","word_count":138,"total_views":"59","reactions":{"happy":"0","normal":"0","sad":"1"},"author_info":{"name":"Robert Jan","author_nicename":"infodatacrow-org","author_url":"https:\/\/datacrow.org\/de\/author\/infodatacrow-org\/"},"doc_category_info":[{"term_name":"System Tools","term_url":"https:\/\/datacrow.org\/de\/docs-category\/system-tools\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/docs\/1121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/comments?post=1121"}],"version-history":[{"count":1,"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/docs\/1121\/revisions"}],"predecessor-version":[{"id":1125,"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/docs\/1121\/revisions\/1125"}],"wp:attachment":[{"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/media?parent=1121"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/doc_category?post=1121"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/datacrow.org\/de\/wp-json\/wp\/v2\/doc_tag?post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}