Re: using create table with show fields

At 20:13 +0700 3/7/04, neal wrote: I would like to do something like Create table xyz as show fields from test.abc; Or maybe Select Field from (show fields from test.abc); Is this possible ?, can I treat the execution of 'show fields' as a select statement Thanks, Neal Katz Sounds like you want

using create table with show fields

I would like to do something like Create table xyz as show fields from test.abc; Or maybe Select Field from (show fields from test.abc); Is this possible ?, can I treat the execution of 'show fields' as a select statement Thanks, Neal Katz