批量更新和插入
摘要：
tabel a 和 tabel b将table b中的字段更新到 table a中UPDATE way_dimes_grproll AS a INNER JOIN way_biz_customer AS b ON a.customer_id =b.customer_id SET a.member_id =b.member_id, a.user_id =b.user_id；批量插入INSERT INTO Table2(field1,field2,...) SELECT value1,value2,... FROM Table1 阅读全文
posted @ 2013-07-26 11:31 天地一连线_孤鸿挂飘渺 阅读(200) 评论(0) 推荐(0) 编辑