标签归档:sql语句

批量修改数据库

zblog帖子内容域名批量替换mysql数据库语句:

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
UPDATE zbp_post SET log_Content = replace( log_Content, 'https://old.google.com','https://new.google.com')
UPDATE zbp_post SET log_Content = replace( log_Content, 'https://old.google.com','https://new.google.com')
UPDATE zbp_post SET log_Content = replace( log_Content, 'https://old.google.com','https://new.google.com')

discuz帖子内容页mysql批量替换语句:

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
UPDATE pre_forum_post SET message = replace( message, 'https://old.google.com', 'https://new.google.com')
UPDATE pre_forum_post SET message = replace( message, 'https://old.google.com', 'https://new.google.com')
UPDATE pre_forum_post SET message = replace( message, 'https://old.google.com', 'https://new.google.com')

discuz更新邮件激活状态 继续阅读