Shell Programming and Scripting

supernova:~# echo 'hello world' | tee - | wc

$ echo 'hello world' | wc -w
       2
$ echo 'hello world' | awk '{print NF, $0}'
2

supernova:~# magiccommand 'hello world'
hello world
2
supernova:~# magiccommand 'how are you'
how are you
3
supernova:~# magiccommand 'must be something pretty tricky'
must be something pretty tricky
5

$ echo 'hello world' | awk '{print $0 ORS NF}'
hello world
2

santiago:~$ mysql -e 'SELECT id, name FROM terminal'
+----+------------------+
| id | name             |
+----+------------------+
|  3 | John Smith       |
| 18 | Alan Parker      |
| 41 | Bob Johnson      |
+----+------------------+

santiago:~$ count=$(mysql -e 'SELECT id, name FROM terminal' | wc -l)
santiago:~$ id=$(mysql -e 'SELECT id, name FROM terminal' | tail -1 | cut -f1)

id	name
3	John Smith
18	Alan Parker
41	Bob Johnson

result=$(mysql -e 'SELECT id, name FROM terminal' | awk '{count=NR;id=$1} END{print count" "id}')
count=$(echo $result | awk '{print $1}')
id=$(echo $result | awk '{print $2}')