两个表互相插入数据

insert into Td_safe_InsureParas
(
InsureTypeID,
CityID,
CarTypeID,
CarSeatTypeID,
Item1Value,
Item2Value,
Item3Value,
Item4Value,
Item5Value,
Item6Value,
ResultValue
)
select
InsureTypeID,
CityID,
CarTypeID,
CarSeatTypeID,
Item1Value,
Item2Value,
Item3Value,
Item4Value,
Item5Value,
Item6Value,
ResultValue
from Td_safe_InsureParas where 1=1 and insuretypeid=221 and cityid=1

转载于:https://www.cnblogs.com/sujingnan/archive/2008/03/08/1096240.html