【mysqlメモ①】すべてのフィールド名を抽出

//         
SHOW COLUMNS FROM `role`




//    mysql           
Select COLUMN_NAME   , DATA_TYPE     , COLUMN_COMMENT       
from INFORMATION_SCHEMA.COLUMNS  
Where table_name = 'companies'  ##    
AND table_schema = 'testhuicard'##      
AND column_name LIKE 'c_name'   ##     

// TP5.1 
\think\Db::table('role')->getTableFields();