批量修改mysql 备注

SELECT

concat(

“ALTER TABLE “,

TABLE_SCHEMA,

“.”,

TABLE_NAME,

” CHANGE “,

COLUMN_NAME,

” “,

COLUMN_NAME,

” “,

COLUMN_TYPE,

IF (
    COLUMN_DEFAULT IS NULL,
    " ",
    concat(
        " DEFAULT ",

    IF (
        COLUMN_DEFAULT = ‘‘,
        "‘‘",
        COLUMN_DEFAULT
    )
    )
),

IF (
IS_NULLABLE = ‘NO‘,
” NOT NULL “,
‘‘
),
” COMMENT “,
” “,
“‘”,
LEFT (
COLUMNS .COLUMN_NAME,
instr(COLUMNS .COLUMN_NAME, ‘F‘) – 1
),
“‘;”
)
FROM
information_schema. COLUMNS
WHERE
TABLE_NAME = ‘j_data_wa_grgz‘
AND COLUMNS .COLUMNNAME LIKE ‘%F%‘