Home Sign Up Sign In
proxytoworld
V2EX  ›  问与答

Mysql 在命令行查询时，如果里面字段的值有换行，查出来在命令行下很丑，怎么优化

  •   
  •   proxytoworld · Jun 1, 2021 · 1052 views
    This topic created in 1831 days ago, the information mentioned may be changed or developed.

    如图

  • 换行
  • 命令
  • 字段
  • MySQL
    3 replies  •  2021-06-03 17:08:48 +08:00
    HFcbyqP0iVO5KM05
        1
    HFcbyqP0iVO5KM05  
       Jun 1, 2021 via Android
    在命令最后，分号之前，加 \G
    SjwNo1
        2
    SjwNo1  
       Jun 2, 2021
    买带鱼屏
    maxbon
        3
    maxbon  
       Jun 3, 2021
    \G
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   2765 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 44ms · UTC 15:19 · PVG 23:19 · LAX 08:19 · JFK 11:19
    ♥ Do have faith in what you're doing.