RE: how to list record in column (instead of a row)

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) > > &

Re: how to list record in column (instead of a row)

you can do: select * from table\G 2013/4/24 > 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, b

Re: how to list record in column (instead of a row)

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 U

how to list record in column (instead of a row)

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;