{"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":"database-editor","status":"publish","type":"docs","link":"https:\/\/datacrow.org\/nl\/docs\/database-editor\/","title":{"rendered":"Database-editor"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><em>Menupad: Extra &gt; Database-editor<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">De Database Editor biedt een snelle en directe manier om gegevens in de database te manipuleren. Het overschrijft alle controles op gegevens, dus er moet voorzichtig mee worden omgegaan.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img alt=\"\" fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-49.png\" 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\">Als je niet bekend bent met SQL, kun je de Database Editor beter niet gebruiken, omdat je dan ongewenste wijzigingen kunt aanbrengen.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Je moet ook vertrouwd raken met de syntaxis van <a href=\"https:\/\/hsqldb.org\/doc\/guide\/\">HSQL DB<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Een SQL-instructie maken en uitvoeren<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Voer een SQL-instructie in het invoerveld \"query\" in en druk op \"Uitvoeren\" om de instructie uit te voeren. Er worden fouten weergegeven als de query onjuist was (deze berichten worden niet gegenereerd door Data Crow, maar door de database-engine).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Eerder uitgevoerde statements kunnen worden opgehaald uit de lijst \"Opgeslagen SQL statements\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img alt=\"\" decoding=\"async\" width=\"844\" height=\"71\" src=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-51.png\" 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\">Het resultaat van een select query wordt weergegeven in de tabel \"Query resultaat\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img alt=\"\" decoding=\"async\" width=\"851\" height=\"249\" src=\"https:\/\/datacrow.org\/wp-content\/uploads\/image-50.png\" 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>Menupad: Extra &gt; Database-editor De Database-editor biedt een snelle en directe manier om gegevens in de database te manipuleren. Het overschrijft alle controles...<\/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-07","word_count":138,"total_views":"2","reactions":{"happy":"0","normal":"0","sad":"1"},"author_info":{"name":"Robert Jan","author_nicename":"infodatacrow-org","author_url":"https:\/\/datacrow.org\/nl\/author\/infodatacrow-org\/"},"doc_category_info":[{"term_name":"System Tools","term_url":"https:\/\/datacrow.org\/nl\/docs-category\/system-tools\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/docs\/1121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/comments?post=1121"}],"version-history":[{"count":1,"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/docs\/1121\/revisions"}],"predecessor-version":[{"id":1125,"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/docs\/1121\/revisions\/1125"}],"wp:attachment":[{"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/media?parent=1121"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/doc_category?post=1121"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/datacrow.org\/nl\/wp-json\/wp\/v2\/doc_tag?post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}