根据判断条件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

posted @ 2013-12-04 16:32  xupengzhuo  阅读(2729)  评论(0)    收藏  举报