mysql 查询表结构

 

use information_schema; 

select column_name, column_type, data_type, is_nullable, column_comment from columns where table_name='表名';

 

use ykee_base
show full columns from 表名;