MySQL/196. Delete Duplicate Emails 删除重复的电子邮箱

18 篇文章 0 订阅

题目


 

 

 

代码部分一(1433ms 50.12%)

# Write your MySQL query statement below
DELETE
    a
    FROM Person a,Person b
    WHERE a.Email=b.Email AND a.Id>b.Id;

 

 

代码部分二(933ms 90.55%)

# Write your MySQL query statement below
DELETE
FROM Person
WHERE 
     Id NOT IN(
     SELECT Id
     FROM (SELECT MIN(Id) AS Id FROM Person GROUP BY Email) AS p
     )

 

java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'employeetb1.PRIMARY' at mysql.connector.java@8.0.29/com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) at mysql.connector.java@8.0.29/com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at mysql.connector.java@8.0.29/com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) at mysql.connector.java@8.0.29/com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061) at mysql.connector.java@8.0.29/com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009) at mysql.connector.java@8.0.29/com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320) at mysql.connector.java@8.0.29/com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994) at com.wzh.service.impl.EmployeetvServiceImpl.insert(EmployeetvServiceImpl.java:29) at com.wzh.service.controller.EmployeetvServiceController.insertvalue(EmployeetvServiceController.java:24) at com.wzh.test.EmployeetbTest.main(EmployeetbTest.java:21) 展示1,是继续输入,其他是Exception in thread "main" java.util.NoSuchElementException at java.base/java.util.Scanner.throwFor(Scanner.java:937) at java.base/java.util.Scanner.next(Scanner.java:1594) at java.base/java.util.Scanner.nextInt(Scanner.java:2258) at java.base/java.util.Scanner.nextInt(Scanner.java:2212) at com.wzh.test.EmployeetbTest.main(EmployeetbTest.java:17)
06-10
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值