List:General Discussion« Previous MessageNext Message »
From:Christoph Boget Date:November 13 2007 2:19pm
Subject:Result set flipped on it's axis
View as plain text  
Let's say I have the following table:

CREATE TABLE `Users` (
`id` blahblah,
`firstName` blahblah,
`lastName` blahblah,
`phone` blahblah,
`fax` blahblah,
`email` blahblah
);

If I do "SELECT id, firstName, lastName, email FROM Users, my result set is
returned as follows:

+----+-----------+------------+-------------------------+
| Id | Firstname | LastName   | EmailAddress            |
+----+-----------+------------+-------------------------+
|  1 | John      | Doe        | jdoe@stripped          |
|  2 | Joe       | Bob        | joe.bob@stripped      |
+----+-----------+------------+-------------------------+

as expected.  But I'm wondering if I could somehow form the query such that
the result set is turned on it's axis like so:

+----+--------------+--------------------+
|  1 | Firstname    | John               |
|  1 | LastName     | Doe                |
|  1 | EmailAddress | jdoe@stripped     |
|  2 | Firstname    | Joe                |
|  2 | LastName     | Bob                |
|  2 | EmailAddress | joe.bob@stripped |
+----+--------------+--------------------+

or some approximation thereof?

thnx,
Chris

Thread
Result set flipped on it's axisChristoph Boget13 Nov