Search Results

that depends on settings in my.cnf file.
look for my.cnf at /etc or /etc/mysql and find there settings related to logging.

but the most correct way is not using grep here. Because it potentially can match value from other fields.
Here is an awk solution:
awk '$3!=0012777201 && $3!=0012777202; BEGIN {FS="|"}' 1.txt

try egrep.
it can eat regular expressions
for your case:
egrep -v "001277720[12]" a.txt
or
egrep -v "00127772011|00127772012" a.txt

if you know Java, you can look here (http://poi.apache.org/)