Quick generator, in sql, to create ALTER sql instructions for a set of databases of the same schema on the same MySQL server

multidb-alter-syntax-generator.sql

SELECT 
    CONCAT(
        'ALTER TABLE `', 
        TABLE_SCHEMA, 
	'`.`', 
	TABLE_NAME,
	'` ADD `change-field-name` VARCHAR(5) NULL DEFAULT NULL',
	';'
    ) AS sql_string
FROM 
    information_schema.COLUMNS
WHERE 
    TABLE_SCHEMA LIKE "some-prefix-maybe_%" AND 
    TABLE_NAME = "change-table-name"
GROUP BY
    TABLE_SCHEMA, 
    TABLE_NAME;