批量更新多个表的SQL语句

小龙

批量更新多个表的SQL语句，以修改附件表替换内容为例子

1. UPDATE pre_forum_attachment_0 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
2. UPDATE pre_forum_attachment_1 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
3. UPDATE pre_forum_attachment_2 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
4. UPDATE pre_forum_attachment_3 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
5. UPDATE pre_forum_attachment_4 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
6. UPDATE pre_forum_attachment_5 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
7. UPDATE pre_forum_attachment_6 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
8. UPDATE pre_forum_attachment_7 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
9. UPDATE pre_forum_attachment_8 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');
   
10. UPDATE pre_forum_attachment_9 SET filename = REPLACE(filename, '【.BD1080p.gyzz.mp4', '');

复制代码