{"id":1697,"date":"2021-08-02T06:14:00","date_gmt":"2021-08-01T22:14:00","guid":{"rendered":"https:\/\/wordpress.cine.idv.tw\/?p=1697"},"modified":"2021-08-02T17:25:25","modified_gmt":"2021-08-02T09:25:25","slug":"how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes","status":"publish","type":"post","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/","title":{"rendered":"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">IDE \u7684 Formatter \u683c\u5f0f\u5316\u5de5\u5177, \u96d6\u7136\u53ef\u4ee5\u8b93 SQL \u7a0b\u5f0f\u78bc\u8b8a\u5f97\u6613\u8b80, \u4f46\u662f\u5f88\u591a\u6642\u5019\u4e5f\u6703\u5e6b\u5012\u5fd9, \u8b93\u539f\u672c\u5df2\u7d93\u76f8\u5c0d\u597d\u95b1\u8b80\u7684 SQL \u7a0b\u5f0f\u78bc\u8b8a\u5f97\u96e3\u61c2! \u672c\u7bc7\u5c31\u4f86\u4ecb\u7d39 JetBrains DataGrip \u4e2d, \u5982\u4f55\u958b\u95dc Formatter.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u958b\u555f DataGrip \u7a0b\u5f0f\u4e4b\u5f8c, \u9032\u5165 <strong>File <\/strong>> <strong>Settings <\/strong>> <strong>Editor <\/strong>> <strong>Code Style<\/strong> > <strong>Formatter <\/strong>\u8a2d\u5b9a\u756b\u9762, \u7136\u5f8c\u5c07 <strong>Turn formatter on\/off with markers in code comments<\/strong> \u8a2d\u5b9a\u555f\u7528, \u63a5\u4e0b\u4f86\u5c31\u53ef\u4ee5\u5728\u7a0b\u5f0f\u78bc\u4e2d, \u4f7f\u7528<strong> @formatter:off \/ @formatter:on <\/strong>\u4f86\u958b\u95dc Formatter \u683c\u5f0f\u5316\u5de5\u5177, \u4f8b\u5982:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>-- @formatter:off<br><br>SELECT 'Please do not format this block, formatter! I'd like to keep it this way.' FROM dummy WHERE 1 &lt;> 2;<br><br>-- @formatter:on<br><br>SELECT 'Please do format this block, formatter!'<br>  FROM dummy<br> WHERE 1 &lt;> 2;<\/code><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"444\" data-attachment-id=\"1698\" data-permalink=\"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/datagrip-fomatter-on_off_settings\/\" data-orig-file=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png\" data-orig-size=\"724,444\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"datagrip-fomatter-on_off_settings\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png\" src=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png\" alt=\"\" class=\"wp-image-1698\" srcset=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png 724w, https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings-300x184.png 300w, https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings-230x141.png 230w, https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings-350x215.png 350w, https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings-480x294.png 480w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u53c3\u8003\u8cc7\u6599<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/www.jetbrains.com\/help\/datagrip\/settings-code-style.html#formatter-control\">DataGrip > Reference > Settings\/Preferences dialog > Editor > Code Style > Formatter<\/a><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>IDE \u7684 Formatter \u683c\u5f0f\u5316\u5de5\u5177, \u96d6\u7136\u53ef\u4ee5\u8b93 SQL \u7a0b\u5f0f\u78bc\u8b8a\u5f97\u6613\u8b80, \u4f46\u662f\u5f88\u591a\u6642\u5019\u4e5f\u6703\u5e6b\u5012\u5fd9, \u8b93\u539f\u672c\u5df2\u7d93\u76f8\u5c0d\u597d\u95b1\u8b80\u7684 SQL \u7a0b\u5f0f\u78bc\u8b8a\u5f97\u96e3\u61c2! \u672c\u7bc7\u5c31\u4f86\u4ecb\u7d39 JetBrains DataGrip \u4e2d, \u5982 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","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,"font":"","enabled":false},"version":2}},"categories":[13],"tags":[27,26,54],"class_list":["post-1697","post","type-post","status-publish","format-standard","hentry","category-it","tag-datagrip","tag-jetbrains","tag-sql"],"featured_image_src":null,"author_info":{"display_name":"shortie","author_link":"https:\/\/wordpress.cine.idv.tw\/index.php\/author\/shortie\/"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6<\/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:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\" \/>\n<meta property=\"og:description\" content=\"IDE \u7684 Formatter \u683c\u5f0f\u5316\u5de5\u5177, \u96d6\u7136\u53ef\u4ee5\u8b93 SQL \u7a0b\u5f0f\u78bc\u8b8a\u5f97\u6613\u8b80, \u4f46\u662f\u5f88\u591a\u6642\u5019\u4e5f\u6703\u5e6b\u5012\u5fd9, \u8b93\u539f\u672c\u5df2\u7d93\u76f8\u5c0d\u597d\u95b1\u8b80\u7684 SQL \u7a0b\u5f0f\u78bc\u8b8a\u5f97\u96e3\u61c2! \u672c\u7bc7\u5c31\u4f86\u4ecb\u7d39 JetBrains DataGrip \u4e2d, \u5982 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/\" \/>\n<meta property=\"og:site_name\" content=\"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-01T22:14:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-02T09:25:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png\" \/>\n<meta name=\"author\" content=\"shortie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005:\" \/>\n\t<meta name=\"twitter:data1\" content=\"shortie\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9810\u4f30\u95b1\u8b80\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/\"},\"author\":{\"name\":\"shortie\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#\\\/schema\\\/person\\\/2f7c8d7d06c31412a22aeeeb557c791f\"},\"headline\":\"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316\",\"datePublished\":\"2021-08-01T22:14:00+00:00\",\"dateModified\":\"2021-08-02T09:25:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/\"},\"wordCount\":41,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#\\\/schema\\\/person\\\/2f7c8d7d06c31412a22aeeeb557c791f\"},\"image\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/datagrip-fomatter-on_off_settings.png\",\"keywords\":[\"DataGrip\",\"JetBrains\",\"SQL\"],\"articleSection\":[\"\u8cc7\u8a0a\u79d1\u6280\"],\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/\",\"url\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/\",\"name\":\"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/datagrip-fomatter-on_off_settings.png\",\"datePublished\":\"2021-08-01T22:14:00+00:00\",\"dateModified\":\"2021-08-02T09:25:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/datagrip-fomatter-on_off_settings.png\",\"contentUrl\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/datagrip-fomatter-on_off_settings.png\",\"width\":724,\"height\":444},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/index.php\\\/2021\\\/08\\\/02\\\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9801\",\"item\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#website\",\"url\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/\",\"name\":\"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6\",\"description\":\"\u656c\u754f\u8036\u548c\u83ef\u662f\u667a\u6167\u7684\u958b\u7aef\uff0c \u8a8d\u8b58\u81f3\u8056\u8005\u4fbf\u662f\u8070\u660e\u3002\u7bb4\u8a00\u4e5d:10\",\"publisher\":{\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#\\\/schema\\\/person\\\/2f7c8d7d06c31412a22aeeeb557c791f\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-TW\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/wordpress.cine.idv.tw\\\/#\\\/schema\\\/person\\\/2f7c8d7d06c31412a22aeeeb557c791f\",\"name\":\"shortie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/i2.wp.com\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/111945_400x400.jpg?fit=400%2C400&ssl=1\",\"url\":\"https:\\\/\\\/i2.wp.com\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/111945_400x400.jpg?fit=400%2C400&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i2.wp.com\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/111945_400x400.jpg?fit=400%2C400&ssl=1\",\"width\":400,\"height\":400,\"caption\":\"shortie\"},\"logo\":{\"@id\":\"https:\\\/\\\/i2.wp.com\\\/wordpress.cine.idv.tw\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/111945_400x400.jpg?fit=400%2C400&ssl=1\"},\"sameAs\":[\"https:\\\/\\\/wordpress.cine.idv.tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","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:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/","og_locale":"zh_TW","og_type":"article","og_title":"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","og_description":"IDE \u7684 Formatter \u683c\u5f0f\u5316\u5de5\u5177, \u96d6\u7136\u53ef\u4ee5\u8b93 SQL \u7a0b\u5f0f\u78bc\u8b8a\u5f97\u6613\u8b80, \u4f46\u662f\u5f88\u591a\u6642\u5019\u4e5f\u6703\u5e6b\u5012\u5fd9, \u8b93\u539f\u672c\u5df2\u7d93\u76f8\u5c0d\u597d\u95b1\u8b80\u7684 SQL \u7a0b\u5f0f\u78bc\u8b8a\u5f97\u96e3\u61c2! \u672c\u7bc7\u5c31\u4f86\u4ecb\u7d39 JetBrains DataGrip \u4e2d, \u5982 [&hellip;]","og_url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/","og_site_name":"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","article_published_time":"2021-08-01T22:14:00+00:00","article_modified_time":"2021-08-02T09:25:25+00:00","og_image":[{"url":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png","type":"","width":"","height":""}],"author":"shortie","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005:":"shortie","\u9810\u4f30\u95b1\u8b80\u6642\u9593":"1 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/#article","isPartOf":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/"},"author":{"name":"shortie","@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f"},"headline":"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316","datePublished":"2021-08-01T22:14:00+00:00","dateModified":"2021-08-02T09:25:25+00:00","mainEntityOfPage":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/"},"wordCount":41,"commentCount":0,"publisher":{"@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f"},"image":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/#primaryimage"},"thumbnailUrl":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png","keywords":["DataGrip","JetBrains","SQL"],"articleSection":["\u8cc7\u8a0a\u79d1\u6280"],"inLanguage":"zh-TW","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/","url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/","name":"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316 - \u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","isPartOf":{"@id":"https:\/\/wordpress.cine.idv.tw\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/#primaryimage"},"image":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/#primaryimage"},"thumbnailUrl":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png","datePublished":"2021-08-01T22:14:00+00:00","dateModified":"2021-08-02T09:25:25+00:00","breadcrumb":{"@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/"]}]},{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/#primaryimage","url":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png","contentUrl":"https:\/\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/08\/datagrip-fomatter-on_off_settings.png","width":724,"height":444},{"@type":"BreadcrumbList","@id":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/08\/02\/how-to-turn-jetbrains-datagrip-formatter-on-off-dynamically-in-codes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/wordpress.cine.idv.tw\/"},{"@type":"ListItem","position":2,"name":"JetBrains DataGrip \u4e2d\u5982\u4f55\u8b93 Formatter \u5de5\u5177\u8df3\u904e\u7279\u5b9a SQL \u7a0b\u5f0f\u78bc\u5340\u584a\u4e0d\u57f7\u884c\u683c\u5f0f\u5316"}]},{"@type":"WebSite","@id":"https:\/\/wordpress.cine.idv.tw\/#website","url":"https:\/\/wordpress.cine.idv.tw\/","name":"\u56db\u7dad\u4e8c\u6728\u4e4b\u5bb6","description":"\u656c\u754f\u8036\u548c\u83ef\u662f\u667a\u6167\u7684\u958b\u7aef\uff0c \u8a8d\u8b58\u81f3\u8056\u8005\u4fbf\u662f\u8070\u660e\u3002\u7bb4\u8a00\u4e5d:10","publisher":{"@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wordpress.cine.idv.tw\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-TW"},{"@type":["Person","Organization"],"@id":"https:\/\/wordpress.cine.idv.tw\/#\/schema\/person\/2f7c8d7d06c31412a22aeeeb557c791f","name":"shortie","image":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/i2.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/111945_400x400.jpg?fit=400%2C400&ssl=1","url":"https:\/\/i2.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/111945_400x400.jpg?fit=400%2C400&ssl=1","contentUrl":"https:\/\/i2.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/111945_400x400.jpg?fit=400%2C400&ssl=1","width":400,"height":400,"caption":"shortie"},"logo":{"@id":"https:\/\/i2.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2021\/11\/111945_400x400.jpg?fit=400%2C400&ssl=1"},"sameAs":["https:\/\/wordpress.cine.idv.tw"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2GqAF-rn","jetpack-related-posts":[{"id":3706,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2023\/11\/07\/solution-to-the-problem-that-jetbrains-development-tools-cannot-be-executed-after-installing-macos-sonoma-14-on-imac14-2-27-inch-late-2013-using-opencore-legacy-patcher\/","url_meta":{"origin":1697,"position":0},"title":"iMac14.2 (27-inch, Late 2013) \u4f7f\u7528 OpenCore Legacy Patcher \u5b89\u88dd macOS Sonoma (14 ~ 14.2) \u4e4b\u5f8c, \u7121\u6cd5\u57f7\u884c JetBrains \u958b\u767c\u5de5\u5177\u7684\u89e3\u6c7a\u65b9\u6848","author":"shortie","date":"2023-11-07","format":false,"excerpt":"\u8001\u820a\u7684 Apple \u96fb\u8166\u5728\u5931\u53bb Apple \u5b98\u65b9\u652f\u63f4\u4e4b\u5f8c\uff0c\u5982\u679c\u9084\u60f3\u8981\u7e7c\u7e8c\u4f7f\u7528\u65b0\u7248\u672c\u7684 macOS \uff0c\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3800,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2023\/11\/08\/what-is-the-redundant-else-null-warning-in-my-sql\/","url_meta":{"origin":1697,"position":1},"title":"MySQL &#8220;Redundant ELSE NULL&#8221; \u662f\u751a\u9ebc\u8b66\u544a\u5462?","author":"shortie","date":"2023-11-08","format":false,"excerpt":"\u5728 JetBrains DataGrip \u5de5\u5177\u4e2d\u5be9\u67e5 SQL \u6a94\u6848\u6642\uff0c\u767c\u73fe\u7de8\u8f2f\u5668\u6703\u91dd\u5c0d CASE .\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1325,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2021\/03\/01\/how-to-reset-jetbrains-datagrip-evaluation-period\/","url_meta":{"origin":1697,"position":2},"title":"JetBrains DataGrip \u5df2\u8a66\u7528\u904e\u820a\u7248\u672c\u5f8c, \u7121\u6cd5\u518d\u7e7c\u7e8c\u8a66\u7528\u5f8c\u7e8c\u8f03\u65b0\u7248\u672c\u7684\u9ed1\u624b\u89e3\u6c7a\u65b9\u6848","author":"shortie","date":"2021-03-01","format":false,"excerpt":"\u96d6\u7136\u81ea\u5df1\u6700\u5e38\u7528\u7684\u8cc7\u6599\u5eab\u5de5\u5177\u4e26\u975e JetBrains DataGrip, \u4f46\u662f\u670b\u53cb\u5708\u4ee5\u53ca\u5de5\u4f5c\u4e0a\u7684\u958b\u767c\u5718\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":318,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2018\/01\/10\/jetbrains-datagrip-connector-java-ssl-mysql-amazon-rds\/","url_meta":{"origin":1697,"position":3},"title":"JetBrains DataGrip MySQL Connector\/J ver. 5.1.44 \u7121\u6cd5\u4f7f\u7528 SSL \u9023\u7dda\u81f3 Amazon RDS \u4e0a\u7684 MySQL","author":"shortie","date":"2018-01-10","format":false,"excerpt":"\u6628\u5929\u9084\u5728\u7528 SSL \u9023\u7dda, \u4eca\u5929\u7a81\u7136\u5c31\u4e0d\u80fd\u4f7f\u7528 \u932f\u8aa4\u8a0a\u606f\u5982\u4e0b: java.security.cert\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":804,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2019\/11\/03\/mysql-using-encrypted-connections\/","url_meta":{"origin":1697,"position":4},"title":"MySQL: \u4f7f\u7528\u52a0\u5bc6\u9023\u7dda\u5b58\u53d6 MySQL \u8cc7\u6599\u5eab","author":"shortie","date":"2019-11-03","format":false,"excerpt":"\u70ba\u4e86\u907f\u514d\u7b2c\u4e09\u65b9\u5077\u807d\u81ea\u5df1\u4f7f\u7528\u7684 MySQL \u8cc7\u6599\u5eab\u5de5\u5177\u8207 MySQL \u4f3a\u670d\u5668\u4e4b\u9593\u7684\u901a\u8a0a\uff0c \u6211\u5011\u53ef\u4ee5\u4f7f\u7528\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5869,"url":"https:\/\/wordpress.cine.idv.tw\/index.php\/2025\/03\/02\/software-garden-microsoft-power-platform\/","url_meta":{"origin":1697,"position":5},"title":"\u8edf\u9ad4\u5927\u89c0\u5712\uff1aMicrosoft Power Platform","author":"shortie","date":"2025-03-02","format":false,"excerpt":"Microsoft Power Platform \u662f\u4e00\u5957\u7528\u65bc\u696d\u52d9\u61c9\u7528\u7a0b\u5f0f\u958b\u767c\u7684\u5de5\u5177\u7d44\uff0c\u5305\u62ec\u56db\u500b\u4e3b\u8981\u61c9\u2026","rel":"","context":"\u5728\u300c\u8cc7\u8a0a\u79d1\u6280\u300d\u4e2d","block_context":{"text":"\u8cc7\u8a0a\u79d1\u6280","link":"https:\/\/wordpress.cine.idv.tw\/index.php\/category\/it\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/wordpress.cine.idv.tw\/wp-content\/uploads\/2025\/03\/PowerPlatform-3906095859-icon.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/1697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/comments?post=1697"}],"version-history":[{"count":2,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/1697\/revisions"}],"predecessor-version":[{"id":1700,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/posts\/1697\/revisions\/1700"}],"wp:attachment":[{"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/media?parent=1697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/categories?post=1697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.cine.idv.tw\/index.php\/wp-json\/wp\/v2\/tags?post=1697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}