SELECT CONCAT('ALTER TABLE `', table_name, '` MODIFY `', column_name, '` DATETIME DEFAULT CURRENT_TIMESTAMP;') AS `query`
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = '表名'
AND DATA_TYPE = 'TIMESTAMP';