dolphinscheduler 任务名称批量修改

Posted by 蓝染君

2025年10月28日

On 2025年10月28日

dolphinscheduler 批量导入任务，任务名称修改

SELECT code, 
name, 
LEFT(name, CHAR_LENGTH(name) - 25) AS new_name, 
project_code 
FROM `t_ds_process_definition`
WHERE create_time >= '2025-10-28 10:49:37'
AND project_code = '19482400349888'
AND name REGEXP '_import_[0-9]{17}$';

SELECT count(1)
FROM `t_ds_process_definition`
WHERE create_time >= '2025-10-28 10:49:37'
AND project_code = '19482400349888'
AND name REGEXP '_import_[0-9]{17}$';


UPDATE t_ds_process_definition
SET name = LEFT(name, CHAR_LENGTH(name) - 25)
WHERE create_time >= '2025-10-28 10:49:37'
AND project_code = '19482400349888'
AND name REGEXP '_import_[0-9]{17}$';

SELECT code, 
name, 
LEFT(name, CHAR_LENGTH(name) - 25) AS new_name, 
project_code 
FROM `t_ds_process_definition`
WHERE create_time >= '2025-10-28 10:49:37'
AND project_code = '19482400349888'
AND name REGEXP '_import_[0-9]{17}$';

SELECT count(1)
FROM `t_ds_process_definition`
WHERE create_time >= '2025-10-28 10:49:37'
AND project_code = '19482400349888'
AND name REGEXP '_import_[0-9]{17}$';


UPDATE t_ds_process_definition
SET name = LEFT(name, CHAR_LENGTH(name) - 25)
WHERE create_time >= '2025-10-28 10:49:37'
AND project_code = '19482400349888'
AND name REGEXP '_import_[0-9]{17}$';

文章