Question

mysql插入一行数据，其中一个值为当前该列的最大值，怎么实现？

我使用：
set @a := select max(goodsid) from resulttable
INSERT INTO resulttable (goodsid, url) values (@a+1,'bird')
报错：
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select max(goodsid) from resulttable
INSERT INTO resulttable (goodsid, url) val' at line 1

Answer 1

INSERT INTO resulttable (goodsid, url) select max(goodsid)+1,'bird' from resulttable

Answer 2

INSERT INTO resulttable (goodsid, url) select max(goodsid)+1,'bird' from resulttable

Answer 3

INSERT INTO resulttable (goodsid, url) values ((SELECT MAX(goodsid)+1 form resulttable),'bird')
嵌套一个查询试试

Answer 4

set @a := select max(goodsid) from resulttable ; 这里加个分号就可以了....

Answer 5

是不是少了一个分隔符啊，在resulttable后面加上个分号试试