Hi all, How does one find the next value of a serial item? Given a simple table with a serial primary key, I'd like to get the next available integer key value. eg:
CREATE TABLE foo (
foo_id SERIAL PRIMARY KEY,
name text DEFAULT NULL);
SELECT foo_id, name FROM foo;
>
1|red
2|green
3|blue
SELECT ???;
>
4
Thanks!
Scott
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
