delete
from FS_NS_News
where id not in
(
select min(id)
from FS_NS_News
group by newsTitle
)
from FS_NS_News
where id not in
(
select min(id)
from FS_NS_News
group by newsTitle
)
目的
要删除FS_NS_News表中newsTitle列的重复信息
group by newsTitle
将newsTitle编组
将newsTitle编组
select min(id) from FS_NS_News
id是唯一的编号
取每个组的最小id
id是唯一的编号
取每个组的最小id
where id not in
条件 取反值
条件 取反值
delete from FS_NS_News
删除表内符合条件的记录
删除表内符合条件的记录