在一个表中复制一行,主键是MLID
//INSERT INTO DZJZ_MLWH (COURT_NO,MLID,PXH,AJLB,MLMC,STATE,JB,SFXML) SELECT COURT_NO,'',PXH,AJLB,MLMC,STATE,JB,SFXML FROM DZJZ_MLWH WHERE MLID='';
2024-02-05 21:53:52
在一个表中复制一行,主键是MLID
//INSERT INTO DZJZ_MLWH (COURT_NO,MLID,PXH,AJLB,MLMC,STATE,JB,SFXML) SELECT COURT_NO,'',PXH,AJLB,MLMC,STATE,JB,SFXML FROM DZJZ_MLWH WHERE MLID='';