mysql所有存储过程包含关键字,删除重复数据

SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%sales_station_code%' 
AND ROUTINE_TYPE='PROCEDURE'

 delete from `sales_dd` where id in (
            select id from (
                select id,row_number() over(partition by order_id order by id desc ) cnt from `sales_dd`
                  where pay_date >= '2022-11-01'

              ) a where a.cnt>1
        )