select查出数据后直接inset到另一张表

摘要: INSERT INTO system_organize (organize_id,organize_code,organize_name)SELECT DISTINCT REPLACE(UUID(),'-',''),a_code,a_name FROM sys_fee_aREPLACE(UUID()... 阅读全文
posted @ 2014-06-19 15:21 kevin~kai 阅读(276) 评论(0) 推荐(0)