mysql表结构生成

SELECT @row_number:=@row_number + 1 AS '序号',
       COLUMN_NAME AS '字段名称',
       COLUMN_TYPE AS '字段类型',
       IF(IS_NULLABLE='NO','否','是') AS '是否必填',
       COLUMN_COMMENT AS '注释'
FROM INFORMATION_SCHEMA.COLUMNS, (SELECT @row_number:=0) AS rn
WHERE table_schema = '数据库名'
  AND table_name = '表名';

这样sql语句会返回数据库表的信息，方便生成表结构的excel文件