{"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":"editeur-de-base-de-donnees","status":"publish","type":"docs","link":"https:\/\/datacrow.org\/fr\/docs\/database-editor\/","title":{"rendered":"\u00c9diteur de base de donn\u00e9es"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><em>Chemin de menu : Outils &gt; \u00c9diteur de base de donn\u00e9es<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">L'\u00e9diteur de base de donn\u00e9es offre un moyen rapide et direct de manipuler les donn\u00e9es de la base. Il remplace tous les contr\u00f4les sur les donn\u00e9es et doit donc \u00eatre manipul\u00e9 avec pr\u00e9caution.<\/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\">Si vous n'\u00eates pas familier avec SQL, il est pr\u00e9f\u00e9rable de ne pas utiliser l'\u00e9diteur de base de donn\u00e9es, car vous risquez d'effectuer des modifications non souhait\u00e9es.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vous devrez \u00e9galement vous familiariser avec la syntaxe de <a href=\"https:\/\/hsqldb.org\/doc\/guide\/\">BASE DE DONN\u00c9ES HSQL<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cr\u00e9ation et ex\u00e9cution d'une instruction SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Saisissez une requ\u00eate SQL dans le champ \"query input\" et appuyez sur \"Run\" pour ex\u00e9cuter la requ\u00eate. Des erreurs seront affich\u00e9es si la requ\u00eate est incorrecte (ces messages ne sont pas g\u00e9n\u00e9r\u00e9s par Data Crow mais par le moteur de la base de donn\u00e9es).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Les instructions pr\u00e9c\u00e9demment ex\u00e9cut\u00e9es peuvent \u00eatre r\u00e9cup\u00e9r\u00e9es \u00e0 partir de la liste d\u00e9roulante \"Instructions SQL enregistr\u00e9es\".<\/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\">Le r\u00e9sultat d'une requ\u00eate s\u00e9lective est affich\u00e9 dans le tableau \"R\u00e9sultat de la requ\u00eate\".<\/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>Chemin de menu : Outils &gt; \u00c9diteur de base de donn\u00e9es L'\u00c9diteur de base de donn\u00e9es offre un moyen rapide et direct de manipuler les donn\u00e9es de la base. Il remplace toutes les v\u00e9rifications...<\/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-06","word_count":138,"total_views":"0","reactions":{"happy":"1","normal":"0","sad":"2"},"author_info":{"name":"Robert Jan","author_nicename":"infodatacrow-org","author_url":"https:\/\/datacrow.org\/fr\/author\/infodatacrow-org\/"},"doc_category_info":[{"term_name":"System Tools","term_url":"https:\/\/datacrow.org\/fr\/docs-category\/system-tools\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/docs\/1121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/comments?post=1121"}],"version-history":[{"count":1,"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/docs\/1121\/revisions"}],"predecessor-version":[{"id":1125,"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/docs\/1121\/revisions\/1125"}],"wp:attachment":[{"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/media?parent=1121"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/doc_category?post=1121"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/datacrow.org\/fr\/wp-json\/wp\/v2\/doc_tag?post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}