In my activity_logs
,它包含列:material_name
, user_id
, mod_result
(这标志着测试是否通过/失败),cert_links
。不知何故,用户生成了两倍的条目material_name
与cert_links
列留空。
我可以列出所有重复项user_id
with:
SELECT user_id, material_name, mod_score, cert_links, start_time
FROM activity_logs
WHERE mod_result = 'Pass' AND cert_links = ''
我想删除重复的条目mod_result = 'Fail'
and cert_links = ''
您可以使用:
Delete from activity_logs WHERE mod_result = 'Fail' AND cert_links = '' or ''NULL'
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)