views:

31

answers:

1

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

I get a Syntax error...

A: 

try this -

SHOW COLUMNS FROM (select * from my_table) T

or Directly SHOW COLUMNS FROM my_table

Sachin Shanbhag