Getting the primary key back from a SQL insert with SQLLite

Question

Hi,

I have a SQL table set that looks like this

create table foo ( 
id int primary key asc, data datatype );

create table bar ( 
id int primary key asc, 
fk_foo int,
foreign key(foo_int) references foo(id));

Now, I want to insert a record set.

insert into table foo (data) values (stuff);

But wait - to get Bar all patched up hunkydory I need the PK from Foo. I know this is a solved problem.

What's the solution?

Answer 1

try this

SELECT last_insert_rowid()