DELETE FROMvideo WHEREurl IN ( SELECT id FROM ( SELECT url AS id FROM video GROUP BY url HAVING count( url ) > 1 ) a ) AND id NOT IN ( SELECT pid FROM ( SELECT min( id ) AS pid FROM video GROUP BY url HAVING count( url ) > 1 ) b )
600字范文,内容丰富有趣,生活中的好帮手!