lls758831364的博客

delete from tb_news where id not in ( select max(id) From tb_news Group By title )刚开始用这条语句删除一直不成功然后百度了一下，说是要建立一张临时表于是进行了以下操作先建立一个临时表 CREATE TEMPORARY TABLE tmp_news ( `id` BIGINT(20) )然后执行以下语句d...