ad576882002的博客

今天在写Producers时犯了一个错误MySQL版本：Server version: 8.0.25错误代码：中间代码块忘记加分号;mysql> delimiter //mysql> create procedure showdd() -> begin -> select * from person -> end//后来发现MYSQL Workbench直接可以右键创建Producers，View也是一样，方便很多...

超越妹妹镇楼在建表的时候没有考虑重复数据问题，现在需要对重复数据进行清理MySQL版本：Server version: 8.0.25delete from leetcode.person where personid in(select t1.PersonId from (select PersonId from leetcode.personwhere (FirstName,LastName) in (select FirstName,LastName from leetcode