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  阅读(428)  评论(0)    收藏  举报