2023年9月25日
mysql对date字段往后加一天
摘要： DATE_ADD(recordDate, INTERVAL 1 DAY) as recordDate 阅读全文
posted @ 2023-09-25 15:40 lytcreate 阅读(43) 评论(0) 推荐(0)
删除一个表里面的重复数据且保留ID最小的数据
摘要： DELETE FROM Person WHERE id IN ( SELECT id FROM ( SELECT id, email, row_number() over ( PARTITION BY email ORDER BY id ) AS rone FROM Person ) a WHERE 阅读全文
posted @ 2023-09-25 14:33 lytcreate 阅读(36) 评论(0) 推荐(0)