在一个表中复制一行，主键是MLID
//INSERT INTO DZJZ_MLWH (COURT_NO,MLID,PXH,AJLB,MLMC,STATE,JB,SFXML) SELECT COURT_NO,'111183',PXH,AJLB,MLMC,STATE,JB,SFXML FROM DZJZ_MLWH WHERE MLID='110037';
IDRI 2016-11-30 15:35 原文
在一个表中复制一行，主键是MLID
//INSERT INTO DZJZ_MLWH (COURT_NO,MLID,PXH,AJLB,MLMC,STATE,JB,SFXML) SELECT COURT_NO,'111183',PXH,AJLB,MLMC,STATE,JB,SFXML FROM DZJZ_MLWH WHERE MLID='110037';