![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Search for a string and copy the entire line | forumthreads | UNIX for Dummies Questions & Answers | 3 | 06-29-2009 08:29 AM |
| sort entire line based on part of the string | gurpal2000 | Shell Programming and Scripting | 10 | 08-01-2008 03:59 AM |
| Perl Search and replace entire line | insania | Shell Programming and Scripting | 1 | 05-22-2008 07:45 PM |
| Capture entire line in ps command | MizzGail | Shell Programming and Scripting | 2 | 05-08-2008 01:46 PM |
| Using grep in if statement | chiru_h | Shell Programming and Scripting | 3 | 09-12-2006 11:00 AM |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
||||
|
grep entire statement not just line
(extract from SQL binlog file...)
# at 4960 #080801 14:35:31 server id 4 end_log_pos 195 Query thread_id=63121426 exec_time=0 error_code=0 use d_jds; SET TIMESTAMP=1217581531; UPDATE bid_details set bidding = 3170.37 ,deduction=if((3170.37 < 37.43),0,deduction) where contractID= 'L03550'; # at 5155 #080801 14:35:31 server id 4 end_log_pos 5182 Xid = 917824715 COMMIT; when I grep for table name for e.g. "bidding" from a (binlog) file, it returns only the first line. I want to return the entire sql statement that ends with ";" that can span through 2 or 3 lines. Is it possible? |
| Bookmarks |
| Tags |
| grep |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|