1.把表中唯一数据搜索创建临时表,最后代替原先表。
create table mmmmmm as
SELECT * FROM meriadianannotation
GROUP BY SeriesID HAVING count(SeriesID) > 1;
1.把表中唯一数据搜索创建临时表,最后代替原先表。
create table mmmmmm as
SELECT * FROM meriadianannotation
GROUP BY SeriesID HAVING count(SeriesID) > 1;
转载于:https://www.cnblogs.com/gaara-zhang/p/10002248.html