摘要:
批量增加数据例如:INSERT INTO T_COLUMN_REFER_ARTICLE( COLUMN_ID,GLOBLE_ID) SELECT 10062, 537836 UNION ALL SELECT 10062, 537919 UNION ALL SELECT 10062, 534171这样就加入了三条数据了~~~删除表中重复数据:DELETE FROM T_COLUMN_REFER_ARTICLEWHERE ID NOT IN(SELECT MIN(ID) FROM T_COLUMN_REFER_ARTICLEGROUP BY GLOBLE_ID,COLUMN_ID) 阅读全文