From: spameden (spamedengmail.com)
Date: Sun Apr 28 2013 - 05:24:45 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

you can do:

select * from table\G

2013/4/24 <hsvtbbs.net>

> >>>> 2013/04/24 09:06 -0700, Rajeev Prasad >>>>
> this table has many columns and only 1 record. select * from table;
> generates an unreadable list. how can i list the record as in two columns?
> (column name and its value)? i looked at UNPIVOT, but could not get it to
> work.
> SQL> select * from table UNPIVOTE INCLUDE NULLS;
> select * from table UNPIVOTE INCLUDE NULLS
> * ERROR at line 1: ORA-00933: SQL command not properly ended
> <<<<<<<<
> From MySQL client, if started with flag '-G':
> select * from table
> ego
>
> For the same program there is flag '--auto-vertical-output'.
>
> But it seems you are using Oracle; this is MySQL list.
> In any case, you wrote both 'UNPIVOT' and 'UNPIVOTE'; I suspect the former
> is better.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]