如图,具体语句如下,大家帮忙改下,原来的是SQL Server的语句,现在要改成Mysql的
update Type set Type_Name='Communication', Type_Desc='Phase: Requirement', Parent_Id=(select ID from Type where Type_Name='Requirement' and Parent_Id=0), Order_Number=1 where ID=1;insert into Type
select 'Review','Phase: Requirement',ID,3 from Type where Type_Name='Requirement' and Parent_Id=0;
update Type set Type_Name='Communication', Type_Desc='Phase: Requirement', Parent_Id=(select ID from Type where Type_Name='Requirement' and Parent_Id=0), Order_Number=1 where ID=1;insert into Type
select 'Review','Phase: Requirement',ID,3 from Type where Type_Name='Requirement' and Parent_Id=0;
网上说是不能在update的时候在同一个表做select操作
update Type a,(select ID from Type where Type_Name='Requirement' and Parent_Id=0) b set a.Type_Name='Communication', a.Type_Desc='Phase: Requirement', a.Parent_Id=b.id, a.Order_Number=1 where a.ID=1;insert into Type(Type_Name,Type_Desc,Parent_Id,Order_Number)
select 'Review','Phase: Requirement',ID,3 from Type where Type_Name='Requirement' and Parent_Id=0;
update Type a,type b
set a.Type_Name='Communication', a.Type_Desc='Phase: Requirement', a.Parent_Id=b.id, a.Order_Number=1 where a.ID=1 and b.Type_Name='Requirement' and b.Parent_Id=0;