if exists(select 1 from table2 where id=(select max(id) from myTable))
update tables set qita='1' where id=id=(select max(id) from myTable)
else
insert table2(id,qita)
select (select max(id) from myTable),'1'
update tables set qita='1' where id=id=(select max(id) from myTable)
else
insert table2(id,qita)
select (select max(id) from myTable),'1'
用SUM求出一值后,直接用SQL插入到另一表中
比如:select sum(money) from table;
insert into table2(money)value(--sum(money--);
可不可以用一条SQL写出来?
begin
update table2 set qita='1' where id=(select max(id) from table1)
end
else
begin
Insert into table2(id,qita)
select (select max(id) from table1),'1'
end