[How To] MySQL Workbench Syntax ์ƒ‰ ๋ณ€๊ฒฝ

Updated:

  • Workbench Syntax ์ƒ‰ ๋ณ€๊ฒฝ

    ์•ž์„œ ๋‹คํฌ๋ชจ๋“œ๊ฐ€ ์ ์šฉ๋œ workbench์—์„œ syntax ์ƒ‰์„ ์–ด์šธ๋ฆฌ๊ฒŒ ๋ณ€๊ฒฝํ•˜๋ ค๊ณ  ๊ฝค ๋…ธ๋ ฅ์„ ํ–ˆ๋‹ค.

    ๊ฒฐ๋ก ์€ ๋ผ์ดํŠธ๋ชจ๋“œ๋กœ ๋ฐ”๊พธ๋Š”๊ฒŒ ํ›จ์”ฌ ๋‚˜์•„์„œ ๋ผ์ดํŠธ๋ชจ๋“œ๋กœ ๋ฐ”๊ฟจ์ง€๋งŒ..

    syntax ์ƒ‰ ๋ณ€๊ฒฝ์€ preferences๋ฅผ ํ†ตํ•ด ๋ฐ”๊ฟ€ ์ˆ˜ ์—†๋‹ค.

    Applications/MySQLWorkbench.app/Contents/Resources/data ๊ฒฝ๋กœ๋ฅผ ํ†ตํ•ด

    code_editor.xml ํŒŒ์ผ์„ ํด๋ฆญ ํ•œ ํ›„ ์•„๋ž˜ ์ฝ”๋“œ ๋ถ€๋ถ„์„ ์ˆ˜์ •ํ•˜๋ฉด ๋œ๋‹ค.

    ๋‚˜๊ฐ™์€ ๊ฒฝ์šฐ ๋ผ์ดํŠธ ๋ชจ๋“œ์—์„œ ์ฃผ์„์ด ํŒŒ๋ž€์ƒ‰์œผ๋กœ ํ‘œ์‹œ๋˜์–ด ์ดˆ๋ก์ƒ‰์œผ๋กœ ๋ฐ”๊ฟจ๋‹ค.

 <style id="0" fore-color-light="#284444" fore-color-dark="#808a8c" /> <!-- SCE_MYSQL_DEFAULT -->

    <style id="1" fore-color-light="#136d13" fore-color-dark="#0a99e5" /> <!-- SCE_MYSQL_COMMENT -->
    <style id="2" fore-color-light="#136d13" fore-color-dark="#0a99e5" /> <!-- SCE_MYSQL_COMMENTLINE -->
    <style id="21" back-color-light="#F0F0F0" back-color-dark="#404040" /> <!-- SCE_MYSQL_HIDDENCOMMAND -->

    <style id="3" fore-color-light="#63bf8d" fore-color-dark="#63bf8d" /> <!-- SCE_MYSQL_VARIABLE -->
    <style id="4" fore-color-light="#45aa73" fore-color-dark="#45aa73" /> <!-- SCE_MYSQL_SYSTEMVARIABLE -->
    <style id="5" fore-color-light="#45aa73" fore-color-dark="#45aa73" /> <!-- SCE_MYSQL_KNOWNSYSTEMVARIABLE -->

    <style id="6" fore-color-light="#cc6c00" fore-color-dark="#e57a00" /> <!-- SCE_MYSQL_NUMBER -->
    <style id="12" fore-color-light="#dd7a00" fore-color-dark="#f28600" /> <!-- SCE_MYSQL_SQSTRING -->
    <style id="13" fore-color-light="#dd7a00" fore-color-dark="#f28600" /> <!-- SCE_MYSQL_DQSTRING -->

    <style id="7" bold="Yes" fore-color-light="#007FBF" /> <!-- SCE_MYSQL_MAJORKEYWORD -->
    <style id="8" bold="Yes" fore-color-light="#007FBF" /> <!-- SCE_MYSQL_KEYWORD -->
    <style id="15" fore-color-light="#7d7d63" fore-color-dark="#7db27d" /> <!-- SCE_MYSQL_FUNCTION -->
    <style id="10" fore-color-light="#7d7d63" fore-color-dark="#7db27d" /> <!-- SCE_MYSQL_PROCEDUREKEYWORD -->
    <style id="14" bold="Yes" /> <!-- SCE_MYSQL_OPERATOR -->

    <style id="16" fore-color-light="#000000" fore-color-dark="#FFFFFF" /> <!-- SCE_MYSQL_IDENTIFIER -->
    <style id="17" fore-color-light="#993a3e" fore-color-dark="#e5454c" /> <!-- SCE_MYSQL_QUOTEDIDENTIFIER -->

    <style id="22" fore-color-light="#FFFFFF" back-color-light="#A0A0A0" fore-color-dark="#000000" back-color-dark="#404040" bold="Yes" /> <!-- SCE_MYSQL_PLACEHOLDER -->

    <style id="18" fore-color-light="#007F00" fore-color-dark="#00b200" bold="yes"/> <!-- SCE_MYSQL_USER1 -->

Leave a comment