[OT] Re: [ILUG] Oracle question

[Josh Glover]

On 26/05/06, Paschal Nee <paschalnee at gmail.com> wrote:

> So are you taking about the client itself.  For example running the mysql
> client with the --vertical attribute
>
> mysql --vertical -u root -p

You can also do this on a statement-by-statement basis with the MySQL
client. If you terminate a SQL statement with \G (that is, a literal
backslash character, followed by an uppercase G), you get vertical
output. For example:

mysql> select * from categories;
+--------+----------------------+--------+
| cat_id | cat_name             | status |
+--------+----------------------+--------+
|      1 | Web Browsers         |      1 |
|      2 | Perl                 |      1 |
+--------+----------------------+--------+
2 rows in set (0.07 sec)

mysql> select * from categories\G
*************************** 1. row ***************************
  cat_id: 1
cat_name: Web Browsers
  status: 1
*************************** 2. row ***************************
  cat_id: 2
cat_name: Perl
  status: 1
2 rows in set (0.00 sec)


Cheers,
Josh