sql插入数据库 INSERT from

DELETE FROM
 t_City_Partner_Settlement_Extend

INSERT  INTO t_City_Partner_Settlement_Extend
        ( [Status] ,
          Other_Receivable_Amount ,
          Other_Payed_Amount ,
          Js_Id
        )
        SELECT  [Status] ,
                Other_Receivable_Amount ,
                Other_Payed_Amount ,
                Js_Id
        FROM    t_City_Partner_Settlement;

posted @ 2020-01-16 16:38  &小程序&  阅读(1784)  评论(0编辑  收藏  举报