我想insert一条记录,用insert into tablename(a1,a2,a3) values (1,"bb",select max(a3)+1 from tablename),总是不行,
当然,我不想把a3 设成自动增长型.我要手工维护.
用insert into tablename(a3) select max(a3)+1 from tablename)就可以.
有谁能解答.
当然,我不想把a3 设成自动增长型.我要手工维护.
用insert into tablename(a3) select max(a3)+1 from tablename)就可以.
有谁能解答.
可以把变量放进子查询里面吧...
试试
insert into [tablename](a1,a2,a3) select 1,'bb',max(a3) from [tablename]
insert into tablename select 1,"bb",max(a3)+1 from test
这样就正确了
insert into tablename select 1,'bb',max(a3) from tablename