shell讀取blob數(shù)據(jù)？

小漁村

mysql
能夠使用shell往里面插入blob的數(shù)據(jù)
但是往外讀取的時候不好控制啊

比如說有這樣的數(shù)據(jù)，LOG_MESSAGE和LOG_KEYWORD是blob型。
select LOG_NAME,LOG_SUBJECT,LOG_MESSAGE,LOG_KEYWORD,INPUT_DATE from LOG\G;
有很多行：

1. *************************** 1. row ***************************
   
2. LOG_NAME: 10.9.1.1 moblie.log
   
3. LOG_SUBJECT:Log at 200812262250 [ERROR(1)]
   
4. LOG_MESSAGE: 2008-1-2 22:46:28,199 WARN  [authority.service.LoginService#compareLeverageGroup:63] : 00019663 Deal LeverageGroup pass time :14 ms
   
5. 2008-1-6 22:46:28,200 INFO  [lib.security.CheckLogin#insertLoginLog:45] : insert login info...customerId:00019663  userAgent:DoCoMo/2.0 P904i(c100;TB;W24H15;ser352880015552747;icc8981100010543834700F)  channel:mob
   
6. 2008-12-26 22:46:28,240 INFO  [info.dao.SessionDAO#saveSessionData:91] : insert Session data table Jhf_Customer_Session with customerId:00019663 sessionID: 990247304395527628 date:Fri Dec 26 22:46:28 JST 2008,channelID:MOB
   
7. 2008-12-26 22:46:28,242 INFO  [authority.action.QuickLoginAction#dologinquick:366] : quicklogin sucess, , phoneUID=icc8981100010543834700F, customerID=00019663
   
8. 2008-12-26 22:46:28,901 INFO  [info.position.PositionReceiver#onMessage:70] : ======================get JMS message:===================00037538
   
9. 2008-12-26 22:46:30,969 ERROR [lib.util.CurrencyUtil#getCurrencyPairInfo:81] : no data found according to the codeOrName!000000
   
10. 2008-12-26 22:46:34,736 INFO  [dispatch.listener.DispatchListener#onMessage:39] : Receive Info For RealTime !!!
    
11. 2008-12-26 22:46:34,737 INFO  [dispatch.listener.DispatchListener#onMessage:40] : Receive message !!!OrderResponseInfo:[priceId=20081226DBPD71d2e82c-02ea-460d-aa86-e12c6d7608df,currencyPair=null,productId=null,orderId=20081226ORD06070198,tradeId=null,fxOrderId=null,customerId=null,side=0,amount=null,executionPrice=null,tradeDate=null,valueDate=null,timequoteId=null,timequoteFlag=false,routeFlag=0,successFlag=false,errorCode=4088,errorMsg= RealTime Order Is Invalid!]
    
12. 2008-12-26 22:46:35,013 INFO  [info.position.PositionReceiver#onMessage:70] : ======================get JMS message:===================00041095
    
13. 2008-12-26 22:46:35,885 INFO  [common.util.BeanUtil#getRate:763] : checkPrice start
    
14. 2008-12-26 22:46:35,886 INFO  [common.util.BeanUtil#getRate:767] : pairCode = USD/JPY
    
15. LOG_KEYWORD: ERROR
    
16. ERROR [lib.util.CurrencyUtil#getCurrencyPairInfo:81] : no data found according to the codeOrName!000000
    
17. INPUT_DATE: 2008-12-26 22:50:05
    
18. *************************** 2. row ***************************
    
19.    LOG_NAME: 10.9.1.31 web.log
    
20. LOG_SUBJECT:  Log at 200812262251 [ERROR(3)]
    
21. LOG_MESSAGE: 2008-12-26 22:51:16,951 INFO  [core.custtrade.WriteOrderServiceImpl#abortOrder:1300] : abortOrder->obean.getOrderStatus() = 2
    
22. 2008-12-26 22:51:16,952 INFO  [core.custtrade.WriteOrderServiceImpl#abortOrder:1302] : abortOrder->obean.getTradeType() = 1
    
23. 2008-12-26 22:51:16,954 INFO  [core.dao.ContractDao#abortSettleOrderToContract:195] :  contract.AmountSettling:20000.00
    
24. 2008-12-26 22:51:16,955 INFO  [core.dao.ContractDao#abortSettleOrderToContract:196] :  order.getOrderAmount:20000.00
    
25. 2008-12-26 22:51:16,958 INFO  [core.dao.OrderDao#cancelOrder:4357] : cancelOrder->order number 0
    
26. 2008-12-26 22:51:16,958 ERROR [core.dao.OrderDao#cancelOrder:4381] : problem  e r r
    
27. cn.bestwiz.jhf.core.bo.exceptions.DaoException: order status is not (0,1) ,so can not cancel ,orderId:20081226ORD06070028
    
28.         at cn.bestwiz.jhf.core.dao.OrderDao.cancelOrder(OrderDao.java:4359)
    
29.         at cn.bestwiz.jhf.core.custtrade.WriteOrderServiceImpl.abortOrder(WriteOrderServiceImpl.java:1298)
    
30.         at cn.bestwiz.jhf.core.custtrade.WriteOrderServiceImpl.abortOrder(WriteOrderServiceImpl.java:1549)
    
31.         at cn.bestwiz.jhf.frontdesk.agent.OrderAgent.abortOrder(OrderAgent.java:423)
    
32. --
    
33.         at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
    
34.         at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
    
35.         at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
    
36.         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
    
37.         at java.lang.Thread.run(Thread.java:619)
    
38. 2008-12-26 22:51:16,959 ERROR [core.custtrade.WriteOrderServiceImpl#abortOrder:1322] : abortOrder failed
    
39. cn.bestwiz.jhf.core.bo.exceptions.DaoException: Exception  error
    
40.         at cn.bestwiz.jhf.core.dao.OrderDao.cancelOrder(OrderDao.java:4382)
    
41.         at cn.bestwiz.jhf.core.custtrade.WriteOrderServiceImpl.abortOrder(WriteOrderServiceImpl.java:1298)
    
42.         at cn.bestwiz.jhf.core.custtrade.WriteOrderServiceImpl.abortOrder(WriteOrderServiceImpl.java:1549)
    
43.         at cn.bestwiz.jhf.frontdesk.agent.OrderAgent.abortOrder(OrderAgent.java:423)
    
44.         at cn.bestwiz.jhf.frontdesk.trade.biz.logic.OrderChangeHandler.buildOrderResponseData(OrderChangeHandler.java:189)
    
45. --
    
46.         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
    
47.         at java.lang.Thread.run(Thread.java:619)
    
48. Caused by: cn.bestwiz.jhf.core.bo.exceptions.DaoException: order status is not (0,1) ,so can not cancel ,orderId:20081226ORD06070028
    
49.         at cn.bestwiz.jhf.core.dao.OrderDao.cancelOrder(OrderDao.java:4359)
    
50.         ... 32 more
    
51. 2008-12-26 22:51:16,961 WARN  [core.custtrade.WriteOrderServiceImpl#abortOrder:1579] : abortOrder failed code:4090 message: cn.bestwiz.jhf.core.bo.exceptions.DaoException: Exception  error
    
52. 2008-12-26 22:51:16,962 WARN  [frontdesk.agent.OrderAgent#abortOrder:444] : code:4090 message: cn.bestwiz.jhf.core.bo.exceptions.DaoException: Exception  error
    
53. 2008-12-26 22:51:16,963 INFO  [core.custtrade.WriteOrderServiceImpl#abortOrder:1561] : abortOrder send AlertFrontInfo Start
    
54. 2008-12-26 22:51:16,979 INFO  [core.custtrade.WriteOrderServiceImpl#abortOrder:1563] : abortOrder send AlertFrontInfo End
    
55. 2008-12-26 22:51:16,980 INFO  [info.position.PositionReceiver#onMessage:70] : ======================get JMS message:===================00032907
    
56. 2008-12-26 22:51:16,988 INFO  [core.custtrade.WriteOrderServiceImpl#checkAccountStatusIfCancel:1227] : checkAccountStatusIfCancel->cts.getId() = 00032907
    
57. 2008-12-26 22:51:16,988 INFO  [core.custtrade.WriteOrderServiceImpl#checkAccountStatusIfCancel:1229] : checkAccountStatusIfCancel->cts.getAccountStatus() = 0
    
58. LOG_KEYWORD: ERROR
    
59. ERROR [core.custtrade.WriteOrderServiceImpl#abortOrder:1322] : abortOrder failed
    
60. ERROR [core.dao.OrderDao#cancelOrder:4381] : problem  e r r
    
61. INPUT_DATE: 2008-12-26 22:52:02

復(fù)制代碼

想弄出如下效果：

1. LOG_NAME                        LOG_SUBJECT                LOG_MESSAGE        LOG_KEYWORD   INPUT_DATE
   
2. 
   
3. 10.9.1.1 moblie.log  Log at 200120050 [ERROR(1)]  ...........................    ...............    2008-12-26 22:50:05
   
4. 10.9.1.31 web.log   Log at 200812262251 [ERROR(3)] ...........................    .........    2008-12-26 22:52:02
   
5.                                                                                        blob數(shù)據(jù)          blob數(shù)據(jù)
   

復(fù)制代碼

但是用shell好難實現(xiàn)啊
請教各位高手

[ 本帖最后由 小漁村 于 2008-12-27 00:30 編輯 ]

welcome008

我認(rèn)為組織成為你那樣的格式更亂

你這樣，一條記錄下來，就占了N多行，而且message后面的那個字段也對不齊

愛知

awk '/^(LOG_NAME|LOG_SUBJECT|INPUT_DATE)/{if(/^LOG_NAME/) printf "\n";sub(/[^:]*:/,""); printf $0;} END{print ""}' ufile