更改字段值：UPDATE qb_cms_content1
SET status = 1;
2.修复某个表;REPAIR TABLE douhao_article;
3.批量修改时间戳：
SET @num := 1701560980, @increment := 7;
替换标题内容：
UPDATE qb_cms_content SET title = REPLACE(title, '%', '个半分比');
-- 更新 qb_cms_content 表
UPDATE qb_cms_content
SET create_time = (@num := @num + @increment)
WHERE create_time >= 1701560980
ORDER BY create_time;
-- 更新 qb_cms_content1 表
UPDATE qb_cms_content1
SET create_time = (@num := @num + @increment)
WHERE create_time >= 1701560980
ORDER BY create_time;
DELETE t1
FROM qb_cms_content1 t1
JOIN qb_cms_content1 t2 ON t1.title = t2.title
WHERE t1.id > t2.id;
DELETE t1
FROM qb_cms_content t1
JOIN qb_cms_content t2 ON t1.title = t2.title
WHERE t1.id > t2.id;
-- 删除表qb_cms_content1中的重复记录
DELETE FROM qb_cms_content1
WHERE title IN (
SELECT title
FROM qb_cms_content1
GROUP BY title
HAVING COUNT(*) > 1
);
-- 删除表qb_cms_content中的重复记录
DELETE FROM qb_cms_content
WHERE title IN (
SELECT title
FROM qb_cms_content
GROUP BY title
HAVING COUNT(*) > 1
);
