SQL添加唯一索引

admin

-- 添加唯一约束
ALTER TABLE LJACCOUNT_MD
ADD CONSTRAINT uk_user_id_no UNIQUE (USER_ID_NO);

-- 删除重复数据（保留一条）或查
DELETE FROM LJACCOUNT_MD
WHERE ROWID NOT IN (
    SELECT MIN(ROWID)
    FROM LJACCOUNT_MD
    GROUP BY USER_ID_NO
    HAVING COUNT(*) >= 1
);