nest SELECT in INSERT

Question

I'm trying to do something like:

INSERT INTO stories 
   (vid, ip, body, timestamp) 
VALUES (
   (SELECT vid+1 FROM stories ORDER BY vid DESC LIMIT 1), 
   INET_ATON('127.0.0.1'), 
   'test', 
   NOW()
)

but I'm having a problem figuring out how to nest a SELECT statement's returned data into an INSERT statement. I need to figure out how to get the highest existing vid and increment it by 1.

Any ideas?

Answer 1

use an explicit SELECT, not nested

INSERT INTO stories 
   (vid, ip, body, timestamp) 
SELECT
   COALESCE(MAX(vid),0)+1,    --max always returns one row if no group by
   INET_ATON('127.0.0.1'), 
   'test', 
   NOW()
FROM stories
ORDER BY vid DESC LIMIT 1