List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:August 16 2005 9:10am
Subject:Re: how to arrange my table in another direction
View as plain text  
Hello.

Your question isn't clear enough for me. Do you want that values
in 'type' column of the first table to become column names
in the second table? Or do you want just to see results in a row?


$$ $ <afcn0@stripped> wrote:
> [-- text/plain, encoding 8bit, charset: gb2312, 17 lines --]
> 
> My table is:
> type   price
> car    1000
> bike   100
> 
> 
> I want the result:
> 
> car      bike
> 1000    100
> 
> I don't know how to get that result.
> 
>                
> ---------------------------------
> DO YOU YAHOO!?
>  $$$$$$$$$$$2G$$$$$pop3$$$$$$$$$$ 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
how to arrange my table in another direction维斯 苏16 Aug
  • Re: how to arrange my table in another directionGleb Paharenko16 Aug
  • Re: how to arrange my table in another directionGleb Paharenko16 Aug
    • Re: how to arrange my table in another direction维斯 苏17 Aug
  • Re: how to arrange my table in another directionPeter Brawley17 Aug
re:how to arrange my table in another direction维斯 苏17 Aug
  • Re: how to arrange my table in another directionPeter Brawley17 Aug