mysql數據庫去重語句和不同表之間列的復制語句，mysql數據庫

mysql數據庫去重語句和不同表之間列的復制語句，mysql數據庫

1.去重語句：DELETE FROM `v_klg_item` WHERE id NOT IN (SELECT * FROM (SELECT MAX(id) FROM `v_klg_item` GROUP BY NAME) AS tmp);

2.數據庫不同表之間列的復制語句：INSERT INTO crm_add (id,address,pid) SELECT id,NAME,parentId FROM labos_area;