<insert id="insert">
insert into sys_menu(name,url,parent_id,order_num)
select #{name},#{url},#{parentId}
,ifnull((select max(order_num)+1 from sys_menu where parent_id=#{parentId}),1)
insert into sys_menu(name,url,parent_id,order_num)
select #{name},#{url},#{parentId}
,ifnull((select max(order_num)+1 from sys_menu where parent_id=#{parentId}),1)
</insert>
ifnull
如果菜单不是空,这样的话新增的菜单按排序按最大max(order_num)+1排序,如果为空就是1