show columns from (select * from (select * from my_table) as T) ?????
I get a Syntax error...
show columns from (select * from (select * from my_table) as T) ?????
I get a Syntax error...
try this -
SHOW COLUMNS FROM (select * from my_table) T
or Directly SHOW COLUMNS FROM my_table