2 | d|
>
> +--+--+
> 4 rows in set (0.00 sec)
>
> - Original Message -
> From: "Rolando Edwards" <[EMAIL PROTECTED]>
> To: "Stefan Kuhn" <[EMAIL PROTECTED]>
> Cc: "MySQL"
> Sent: Monday, July 16, 2007 9:44:
c|
|2 | d|
+--+--+
4 rows in set (0.00 sec)
- Original Message -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Stefan Kuhn" <[EMAIL PROTECTED]>
Cc: "MySQL"
Sent: Monday, July 16, 2007 9:44:48 AM (GMT-0500) America/New_York
Su
der by 1;
select * from test.RotatedData;
- Original Message -
From: "Stefan Kuhn" <[EMAIL PROTECTED]>
To: "MySQL"
Sent: Monday, July 16, 2007 8:58:58 AM (GMT-0500) America/New_York
Subject: Putting two queries in one
Hi all,
I have to create a view. For this, a
Hi all,
I have to create a view. For this, a table needs to transformed like this:
So the original table is
1 a b
2 c d
I want
1 a
1 b
2 c
2 d
I can do two queries giving me this, but how do I combine them in a view? If a
new table would need to be created, I could do a select into - but in a view
