Mysql

替换某个字段里的特定字符串

UPDATE narticles SET content = REPLACE(content, '2020', '2021');
UPDATE narticles SET title = REPLACE(title, '2020', '2021');
UPDATE narticles SET meta_info = REPLACE(meta_info, '2020', '2021');

完整复制一张表

CREATE TABLE narticles LIKE narticles_2021;
INSERT INTO narticles SELECT * FROM narticles_2021;