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

显示全部楼层 · 2011-3-8 12:32:51

我使用：
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

千问 · 2011-3-8 12:32:51

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

千问 · 2011-3-8 12:32:51

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

千问 · 2011-3-8 12:32:51

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

千问 · 2011-3-8 12:32:51

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