1.数据库删除重复数据
delete from 表名 a
where a.rowid !=
(
select max(b.rowid) from 表名 b
where a.字段1 = b.字段1 and
a.字段2 = b.字段2
)
2.通过dual查询(使用函数)
select 7 from dual;
3.获取32位UUID
SELECT REPLACE(uuid(), '-', '');
delete from 表名 a
where a.rowid !=
(
select max(b.rowid) from 表名 b
where a.字段1 = b.字段1 and
a.字段2 = b.字段2
)
select 7 from dual;
SELECT REPLACE(uuid(), '-', '');