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's Center:
>Email: orasnita@stripped

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