Or
SELECT ... \G
(replace ';' with '\G')
-Original Message-
From: h...@tbbs.net [mailto:h...@tbbs.net]
Sent: Wednesday, April 24, 2013 9:55 AM
To: mysql list
Subject: Re: how to list record in column (instead of a row)
2013/04/24 09:06 -0700, Rajeev Prasad
this table has
you can do:
select * from table\G
2013/4/24 h...@tbbs.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,
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