sql生成删除多个表的sql语句再复制运行删除

sql生成删除多个表的sql语句再复制运行删除，已达到删除多表的数据

-- SELECT CONCAT("UPDATE ",  table_name, " SET  school_id='dapeng';") as gosql FROM
--   information_schema.tables
-- WHERE
--   table_schema = 'dapeng';


-- UPDATE advertisement SET  school_id='dapeng';
-- UPDATE announcement SET  school_id='dapeng';
-- UPDATE announcement_comment SET  school_id='dapeng';
-- UPDATE answer SET  school_id='dapeng';
-- UPDATE answer_like SET  school_id='dapeng';
-- UPDATE answer_vote SET  school_id='dapeng';
-- UPDATE category SET  school_id='dapeng';