在一个表中复制一行,主键是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';
在一个表中复制一行,主键是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';
转载于:https://www.cnblogs.com/IDRI/p/6118042.html