[SQL ] 關於用putty搜尋mysql資料庫顯示問題

看板Database作者 (bear)時間13年前 (2011/05/12 10:46), 編輯推噓0(0推 0噓 2→)
留言2則, 2人參與, 最新討論串1/1
不知道板上是否有板友曾經利用putty在瀏覽mysql資料庫的~ 因為如果當資料表中某欄位過長時, 顯示在putty上就會很亂, 很不好瀏覽~ 就要將他另外貼出來看, 不知道有沒有方法可以分列瀏覽或是有更好的顯示方式!! 以下是所說的不好瀏覽的範例: ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------+-----------+---------------+----------------------------------+---------------------+----------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------+----------+------------+------------+-----------+-------------+------------+----------------+---------------------+---------------------+-----------+-----------+------------+--------------+------------+------------+--------------+---------+---------+-----------+-------------+-----------+ | 1000001 | xxxxx | 1111122224444 | 2011-03-28 09:48:13 | 1pp | 1 | 2:3:9:14:18:23:26 | | | lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_ TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;;lang:::zh_TW.Big5;;; | 0 | dddkkwww | 一串數字 | name,company,nick_name,last_name | company,compID | 850:900:849:103:116:112:448:449:450:455:456:467:473:478:480:485:486:488:489:491:492:494:495:497:498:499:500:1000:1001:1002:1003:1004:1005:1006:2001:3000:3001:3585:459:704:705:562:563:564:565:566:567:1204:2802:2803 | 62914560 | 40214427 | NULL | NULL | ALL | O519O4ENVI | 0 | 2011-05-12 09:16:10 | 2011-04-26 10:24:57 | NULL | NULL | NULL | NULL | 0000-00-00 | 0000-00-00 | NULL | 0 | 0 | 0 | 0 | | 感謝大家!! -- ╗ ╗ ║ ║ ╔═╗╠═╗╔═╗╗═╗╔═╗ ╠═╗╔═╗ ╗═╗ ║ ║ ║╠═╝║ ║║ ║ ║║ ║ ║ ║ ╚═╝╜ ╨╚═╝╜ ╜╚═╝ ╜ ╨╚═╩ ╜ ╜ -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 59.125.130.40
→
05/12 22:39, , 1F
不要用;改用\G就好
05/12 22:39, 1F
→
05/25 16:09, , 2F
謝囉^^ 好用!!
05/25 16:09, 2F
‣ 更多 chenchan 的文章
文章代碼(AID): #1Doqdv8I (Database)