摘要: 批量增加数据例如: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) 阅读全文
posted @ 2014-01-08 19:40 天殇月痕 阅读(306) 评论(0) 推荐(0) 编辑