查找没有注释的字段，并生成相应的语句

    SELECT table_name,
    column_name,
    CONCAT(‘ALTER TABLE ',<br /> table_name,<br /> ' CHANGE ',<br /> column_name,<br /> ' ',<br /> column_name,<br /> ' ‘,
    column_type,
    ‘ ‘,
    IF(is_nullable = ‘YES’, ‘’ , ‘NOT NULL ‘),
    IF(column_default IS NOT NULL, concat(‘DEFAULT ‘, IF(column_default = ‘CURRENT_TIMESTAMP’, column_default, CONCAT(‘\’’,column_default,’\’’) ), ‘ ‘), ‘’),
    IF(column_default IS NULL AND is_nullable = ‘YES’ AND column_key = ‘’ AND column_type = ‘timestamp’,’NULL ‘, ‘’),
    IF(column_default IS NULL AND is_nullable = ‘YES’ AND column_key = ‘’,’DEFAULT NULL ‘, ‘’),
    extra,
    ‘ COMMENT \’’,
    column_comment,
    ‘\’ ;’) as script
    FROM
    information_schema.columns
    WHERE
    table_schema = ‘test’
    and column_comment=’’
    ORDER BY table_name , column_name;

    | dbinfo | dbsize | ALTER TABLE dbinfo CHANGE dbsize dbsize float DEFAULT NULL COMMENT ‘’ ;
    | dbinfo | name | ALTER TABLE dbinfo CHANGE name name varchar(10) DEFAULT NULL COMMENT ‘’ ;
    | dbinfo | sqlcount | ALTER TABLE dbinfo CHANGE sqlcount sqlcount int(11) DEFAULT NULL COMMENT ‘’ ;