Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Linux Ask!

Jan 072008
 

How to use pipe in Linux

Answer:

Pipe | is very useful when you want to redirect the output of a program as an input of another program.

The combinations of using pipe in Linux is almost unlimited.

Some common usage:

1. count the number of lines in a file

cat test.txt | wc -l

2. read a very large text file

cat large.txt | less

3. filter filename from find util

find -type f | grep foo.txt

May 132007
 

Convert IP address to unsigned integer in MySQL

Answer:

To convert an IPv4 address string, such as 127.0.0.1 to an unsigned integer, you can use the INET_ATON function in MySQL.

mysql> SELECT INET_ATON('127.0.0.1');

+------------------------+
| INET_ATON('127.0.0.1') |
+------------------------+
|             2130706433 |
+------------------------+