Mysql 快速生成 IDE 可识别的model类注解 (PHP适用)

SELECT
    CONCAT(
        ' * @property ',
        CASE -- Mysql数据类型 -> PHP数据类型 （可自行添加）
    WHEN DATA_TYPE = 'tinyint' THEN
        'int'
    WHEN DATA_TYPE = 'smallint' THEN
        'int'
    WHEN DATA_TYPE = 'mediumint' THEN
        'int'
    WHEN DATA_TYPE = 'integer' THEN
        'int'
    WHEN DATA_TYPE = 'int' THEN
        'int'
    WHEN DATA_TYPE = 'bigint' THEN
        'int'
    WHEN DATA_TYPE = 'float' THEN
        'float'
    WHEN DATA_TYPE = 'double' THEN
        'float'
    WHEN DATA_TYPE = 'decimal' THEN
        'float'
    WHEN DATA_TYPE = 'date' THEN
        'string'
    WHEN DATA_TYPE = 'time' THEN
        'string'
    WHEN DATA_TYPE = 'year' THEN
        'string'
    WHEN DATA_TYPE = 'datetime' THEN
        'string'
    WHEN DATA_TYPE = 'timestamp' THEN
        'string'
    WHEN DATA_TYPE = 'char' THEN
        'string'
    WHEN DATA_TYPE = 'varchar' THEN
        'string'
    WHEN DATA_TYPE = 'tinyblob' THEN
        'string'
    WHEN DATA_TYPE = 'tinytext' THEN
        'string'
    WHEN DATA_TYPE = 'blob' THEN
        'string'
    WHEN DATA_TYPE = 'text' THEN
        'string'
    WHEN DATA_TYPE = 'mediumblob' THEN
        'string'
    WHEN DATA_TYPE = 'mediumtext' THEN
        'string'
    WHEN DATA_TYPE = 'longblob' THEN
        'string'
    WHEN DATA_TYPE = 'longtext' THEN
        'string'
    WHEN DATA_TYPE = 'json' THEN
        'string'
    WHEN DATA_TYPE = 'enum' THEN
        'string'
    ELSE
        'string'
    END,
    ' $',
    COLUMN_NAME,
    ' ',
    COLUMN_COMMENT
    ) AS '注解'
FROM
    information_schema.`COLUMNS` -- 数据来源（不可修改）
WHERE
    TABLE_SCHEMA = 'db_name' -- 数据库名
AND TABLE_NAME = 'table_name' -- 表名

本作品采用《CC 协议》，转载必须注明作者和本文链接