新年第一帖。sql 语句问题
insert into test values(select max(id)+2 from test,’test’)
这个sql现在语句是错误的。正确应怎么去实现将select 的结果当作其中一个值插入新的记录中去
insert into test select max(id)+2,’test’ from test
insert into test(字段1，字段2) select max(id)+2,’test’ from test
-
SQL code
insert into test select max(id)+2,'test' from test
insert into test select max(id)+2,'test' from test
