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
