生成全库替换SQL

生成SQL

SELECT CONCAT('UPDATE ', TABLE_SCHEMA, '.', TABLE_NAME, ' SET ', COLUMN_NAME, ' = REPLACE(', COLUMN_NAME, ', ''oldword'', ''newword'');') FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA not in ('mysql','performance_schema','sys','test','information_schema') AND DATA_TYPE IN ('char', 'varchar', 'text');