1.查看表说明

  1. select * from information_schema.TABLES where TABLE_SCHEMA = 'company-demo';

2.查看表列属性定义说明

  1. select * from information_schema.COLUMNS where TABLE_SCHEMA = 'company-demo' and TABLE_NAME = 'system_task_notify';

3.查看表结构

  1. show CREATE table system_task_notify;