作者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