sybase SQL记录

在一个表中复制一行,主键是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';

 

posted @ 2016-11-30 15:35  yhidr  阅读(278)  评论(0编辑  收藏  举报