I have a table, with autoincremented id
CREATE TABLE users (
id SERIAL NOT NULL,
name VARCHAR(30) NOT NULL,
PRIMARY KEY (id)
)
I can add a new item there with an explicit id
INSERT INTO users (id, name) VALUES (2, 'fred')
And while my id is autoincremented, I can omit it
INSERT INTO users (name) VALUES ('ed')
So, this time, I don't know the id, and I want to somehow get it.
I could do it with LAST_IDENTITY() function, but it just uses %RowID, and have no relation to the primary id