两个表互相插入数据

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/p/1096240.html