Mysql语句的--》新增 查询数据插入、更新 查询数据改变

INSERT into a(shop_id, nav_name, selected_icon_url, unselected_icon_url, path, path_name,
    conf_type, nav_order, status, editor, edit_date)
    SELECT shop_id, nav_name, selected_icon_url, unselected_icon_url, path, path_name, 1, nav_order, status, #{editor}, now()
    from a where shop_id = #{shopId}

UPDATE sf a INNER JOIN sf b
    ON a.nav_order = b.nav_order
    SET  a.nav_name = b.nav_name, a.selected_icon_url= b.selected_icon_url, a.unselected_icon_url = b.unselected_icon_url,
    a.path = b.path, a.path_name = b.path_name, a.status = b.status, a.editor = #{editor}, a.edit_date = now()
    WHERE a.shop_id = b.shop_id and b.shop_id = #{shopId} and b.conf_type = 0