#!/bin/bash -x
echo "Hello world!" >> logfile
echo "Second command!" >> logfile

+ echo 'Hello world!'
Hello world!
+ echo "Second command!"
Second command!

echo "select 1 from dual" | mysql -v --table --user=u --password=p --host=h

--------------
select 1 from dual
--------------

+---+
| 1 |
+---+
| 1 |
+---+