作者chenchan (bear)
看板Database
標題[SQL ] 關於用putty搜尋mysql資料庫顯示問題
時間Thu May 12 10:46:14 2011
不知道板上是否有板友曾經利用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
1F：→ jojobill:不要用;改用\G就好 05/12 22:39
2F：→ chenchan:謝囉^^ 好用!! 05/25 16:09