Re: Selecting from another select?

[Paul DuBois]

At 17:18 +0200 1/19/03, Octavian Rasnita wrote:
>Hi all,
>
>For the query:
>
>show columns from table like 'column';
>
>... I want to get the type field.
>How can I do that?

Into another table?

You can't.  You have to write a program that captures the result
and processes it.

>
>I've tried:
>
>select type from (
>show columns from table like 'column');
>
>But it gave me an error, (as expected).
>
>Thank you
>
>Teddy,
>Teddy's Center: http://teddy.fcc.ro/
>Email: orasnita@stripped