批量修改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 .COLUMN_NAME LIKE '%F_%'