根据判断条件insert into的SQL语句

insert into `mt`.`tasks` (id,task_title,task_type,priority,difficulty)
select `manager_tool`.`vm_tasklist`.id,
`manager_tool`.`vm_tasklist`.title,
`manager_tool`.`vm_tasklist`.type,
`manager_tool`.`vm_tasklist`.priority,
`manager_tool`.`vm_tasklist`.difficulty
from `manager_tool`.`vm_tasklist`
where `manager_tool`.`vm_tasklist`.parent_id = 0

原文地址:https://www.cnblogs.com/xupengzhuo/p/3457852.html