When the number of columns get large, it becomes increasingly
difficult to view the results of a select in a small window (e.g. 80
line xterm) because of line wrapping. Can I have the results of the
select query displayed rotated, e.g. like this:
+------+------+------+------+
| | row0 | row1 | row2 |
+------+------+------+------+
| col0 | 0 | 3 | 6 |
| col1 | 1 | 4 | 7 |
| col2 | 2 | 5 | 8 |
+------+------+------+------+
$ uname -a
Linux mylinux 2.4.20-28.7 i686
mysql> select version();
+------------+
| version() |
+------------+
| 4.0.17-Max |
+------------+
1 row in set (0.00 sec)
mysql> create database foo;
Query OK, 1 row affected (0.00 sec)
mysql> use foo;
Database changed
mysql> create table t (
-> col0 integer,
-> col1 integer,
-> col2 integer
-> );
Query OK, 0 rows affected (0.00 sec)
mysql> insert into t values (0,1,2);
Query OK, 1 row affected (0.00 sec)
mysql> insert into t values (3,4,5);
Query OK, 1 row affected (0.00 sec)
mysql> insert into t values (6,7,8);
Query OK, 1 row affected (0.01 sec)
mysql> select * from t;
+------+------+------+
| col0 | col1 | col2 |
+------+------+------+
| 0 | 1 | 2 |
| 3 | 4 | 5 |
| 6 | 7 | 8 |
+------+------+------+
3 rows in set (0.02 sec)
--