How to SHOW COLUMNS from a SELECT query (rather than a table)?

Asked 2010-09-15T09:47:44.007

I get a syntax error when I run the following:

show columns from (select * from (select * from my_table) as T)

How can I show the columns from a query that I wrote, rather than from a table?

java mysql database-metadata

Edit Report

1 Answer

-3

try this -

SHOW COLUMNS FROM (select * from my_table) T

or Directly SHOW COLUMNS FROM my_table

answered 2010-09-15T09:48:20.437