With the mysql shell, you can get vertical output when executing interactive queries by ending them with \G
instead of ;
.
For example:
mysql> select * from foo limit 1\G
*************************** 1. row ***************************
sid: foo
login: bar
1 row in set (0.00 sec)
Is it possible to do the same using fisql
from FreeTDS?
Alternatively, I will accept an answer that can recommend a better UNIX-compatible command line interface to SQL Server that has this capability.
Thanks!