sql,插入最大值加1

insert into aa (id,name) values((select case when max(id) is null then 1 else max(id)+1 end from aa),'a');

posted @ 2014-01-26 16:26  klj123wan  阅读(412)  评论(0编辑  收藏  举报