Getting the primary key back from a SQL insert with SQLLite
- by Paul Nathan
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?
