先在前端找到要删除的数据流水号，通过流水号查找对应的PROC_INST_ID

SELECT PROC_INST_ID,VALUE FROM process_form_data WHERE VALUE IN 
('SXKJ-20230630-001','SXKJ-20230620-003');

通过PROC_INST_ID删除几个表的数据，删除前先备份表，如果提示关联了主键无法删除，就把备份的表删了删除数据

DELETE FROM process_form_data WHERE proc_inst_id IN ('c699d53e-0f73-11ee-87c1-000c2978deed','56954352-1702-11ee-be95-000c2978deed')
DELETE FROM act_hi_taskinst WHERE PROC_INST_ID_ IN ('c699d53e-0f73-11ee-87c1-000c2978deed','56954352-1702-11ee-be95-000c2978deed')
DELETE FROM act_hi_procinst WHERE PROC_INST_ID_ IN ('c699d53e-0f73-11ee-87c1-000c2978deed','56954352-1702-11ee-be95-000c2978deed')
DELETE FROM act_ru_actinst WHERE PROC_INST_ID_ IN ('c699d53e-0f73-11ee-87c1-000c2978deed','56954352-1702-11ee-be95-000c2978deed')
DELETE FROM act_ru_identitylink WHERE PROC_INST_ID_ IN ('c699d53e-0f73-11ee-87c1-000c2978deed','56954352-1702-11ee-be95-000c2978deed')