Mysql SHOW COLUMNS

Question

It would have to bring only the columns of the bank and order of the form that I want for example:

show columns FROM table

The above code brings up all table columns.

bring the ordered columns.

SHOW TABLE.COLUNA1,
     TABLE.COLUNA2
FROM TABLE

Answer 1

Try to use INFORMATION_SCHEMA:

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';