rich1.0phorkiehttps://p.cweiske.de/inspect certain line in an SQL fileChristian Weiske86400900900<!-- embedding all files of https://p.cweiske.de/405 -->
<link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/>
<div class="phork" id="405">
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.bash .de1, .bash .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.bash {font-family:monospace;}
.bash .imp {font-weight: bold; color: red;}
.bash li, .bash .li1 {color: #DDD;}
.bash .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.bash .kw1 {color: #000000; font-weight: bold;}
.bash .kw2 {color: #c20cb9; font-weight: bold;}
.bash .kw3 {color: #7a0874; font-weight: bold;}
.bash .co0 {color: #666666; font-style: italic;}
.bash .co1 {color: #800000;}
.bash .co2 {color: #cc0000; font-style: italic;}
.bash .co3 {color: #000000; font-weight: bold;}
.bash .es1 {color: #000099; font-weight: bold;}
.bash .es2 {color: #007800;}
.bash .es3 {color: #007800;}
.bash .es4 {color: #007800;}
.bash .es5 {color: #780078;}
.bash .es_h {color: #000099; font-weight: bold;}
.bash .br0 {color: #7a0874; font-weight: bold;}
.bash .sy0 {color: #000000; font-weight: bold;}
.bash .st0 {color: #ff0000;}
.bash .st_h {color: #ff0000;}
.bash .nu0 {color: #000000;}
.bash .re0 {color: #007800;}
.bash .re1 {color: #007800;}
.bash .re2 {color: #007800;}
.bash .re4 {color: #007800;}
.bash .re5 {color: #660033;}
.bash span.xtra { display:block; }
</style><div class="code"><table class="bash"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
5
</pre></td><td class="de1"><pre class="de1">$ mysql ... <span class="sy0"><</span> file.sql
 ERROR <span class="nu0">1054</span> <span class="br0">(</span>42S22<span class="br0">)</span> at line <span class="nu0">154422</span>: Unknown column <span class="st_h">'locked'</span> <span class="kw1">in</span> <span class="st_h">'field list'</span>
 
$ <span class="kw2">sed</span> <span class="re5">-n</span> <span class="st_h">'154422,154425p'</span> file.sql
.. outputs line <span class="kw1">in</span> <span class="kw2">file</span></pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/405/rev-raw/79f4457a9af916b402ad74cfa7d8e613b35a7697/phork0.sh" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/405#phork0.sh">phork0.sh</a>
</div>
</div>
</div>