alter table componentresource add PRIMARY KEY (COMPONENT_ID, LANGUAGE_ID);
------find duplicate records
SELECT COMPONENT_ID, LANGUAGE_ID FROM componentresource t
GROUP BY COMPONENT_ID, LANGUAGE_ID
HAVING COUNT(*) > 1
------find duplicate records
SELECT COMPONENT_ID, LANGUAGE_ID FROM componentresource t
GROUP BY COMPONENT_ID, LANGUAGE_ID
HAVING COUNT(*) > 1
扫一扫
4565
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
