klj123wan

摘要： 移动一个表的数据到新表中保留表中is_checked=1 最后的一条数据CREATE TABLE t_chapter_new2 AS SELECT * FROM t_chapter WHERE id IN(SELECT a.ma FROM(SELECT jidi_id,MAX(id) maFROM t_chapterWHERE is_checked = 1 GROUP BY jidi_id) a)INSERT INTO t_chapter_new2 SELECT * FROM t_chapter WHERE is_checked!=1联表删除：DELETE t_chapter_new2 FRO 阅读全文