MYSQL查询所有表，拼接修改列脚本

select 
t.TABLE_NAME,
GROUP_CONCAT(t.COLUMN_NAME),
CONCAT("UPDATE ",t.TABLE_NAME," set ",GROUP_CONCAT(t.COLUMN_NAME,"=REPLACE(REPLACE(",t.COLUMN_NAME,",\"•\",\"·\"),\"●\",\"·\")"),";")

from information_schema.columns t
where t.table_schema = 'bmp_quota' and t.COLUMN_NAME like '%pro_name' and t.TABLE_NAME NOT like 'v_%' and t.TABLE_NAME NOT like 'vw_%'
and t.TABLE_NAME NOT like '%_copy%'

GROUP BY t.TABLE_NAME ORDER BY t.TABLE_NAME ;