现在的位置: 首页 > 综合 > 正文

本人写了一条SQL语句,复制某条记录

2013年12月02日 ⁄ 综合 ⁄ 共 759字 ⁄ 字号 评论关闭

insert into AgentPayment_info (ID,AGENTID,EnterpriseID,OrderID,AgentDiscount,ProductType,CREATEDATE,keyword,ProductPrice,discountPrice,ActualPrice,ServeYears,FreeYears,PromotionRuleID,EXPLAIN,MagentID,Magent,zoneCode,agentIncome,ParentAgentIncome,companyIncome,AgentType,rakeoffPrice,AgentPrice,stationRakeoffPrice,Prefix,businessType,participleRakeoffPrice)
 select (select max(id)+1 from AgentPayment_info),AGENTID,EnterpriseID,OrderID,AgentDiscount,ProductType,CREATEDATE,keyword,ProductPrice,discountPrice,ActualPrice,ServeYears,FreeYears,PromotionRuleID,EXPLAIN,MagentID,Magent,zoneCode,agentIncome,ParentAgentIncome,companyIncome,AgentType,rakeoffPrice,AgentPrice,stationRakeoffPrice,Prefix,businessType,participleRakeoffPrice
 from AgentPayment_info
 where id=2778

抱歉!评论已关闭.