查询某库某表表的字段信息

不加上某库，查询出来的列可能是多库的

select * from information_schema.columns where  table_name = 'security_user_occupationalhistory'; 

 

select TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='yuncai'  and table_name = 'security_user_educationbackground';
select TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='yuncai'  and table_name = 'security_user_essentialinfo';
select TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='yuncai'  and table_name = 'security_user_immediatefamily';
select TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='yuncai'  and table_name = 'security_user_occupationalhistory';