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 表名;