TIPS » Blog Archive » mysql SQL シェルコマンド㮠TIPSpager, –safe-updates mysql ã§ã‚¯ã‚¨ãƒªã®çµæžœã‚’表示ã™ã‚‹ pager ã«ã¯ “less -S†ãŒãŠã™ã™ã‚ã§ã™ãŒã€ã™ã“ã—å¤ã„ less ã ã¨ã€UTF-8 ã®å‡¦ç†ãŒã„ã¾ã„ã¡ã ã£ãŸã‚Šã™ã‚‹ã®ã§ã€æ–°ã—ã„ less (Version 406 以é™)を使ã†ã®ãŒã‚ˆã„ã§ã—ょã†ã€‚ ã¾ãŸã€äº‹æ•…を防ããŸã‚ã«ã€ã¤ãã«â€“safe-updatesオプションを使ã†ã®ã¯è‰¯ã„考ãˆã§ã™ã€‚ ãã†ã™ã‚‹ã¨ã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãŒ % mysql -h localhost -u username –password=secret \ –pager=â€/some/where/less-408 -S†\ –default-character-set=utf8 \ –safe-updates dbname ã®ã‚ˆã†ã«é•·ããªã‚‹ã®ã§ã€ã‚·ã‚§ãƒ«ã® alias/function ã«ç™»éŒ²ã™ã‚‹ãªã©ã—ã¦ãŠãã¾ã™ã€‚ ã¾ã‚ã“ã®ã‚
{{#tags}}- {{label}}
{{/tags}}