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';