List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 19 2003 6:21pm
Subject:Re: Selecting from another select?
View as plain text  
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

Thread
Selecting from another select?Octavian Rasnita19 Jan
  • Re: Selecting from another select?Paul DuBois19 Jan