On Sun, 8 Sep 2013 22:56:20 +0000
"Joseph L. Casale" <[email protected]> wrote:
> What is the most efficient way to insert several records into a table
> which has a fk ref to the auto incrementing pk of another insert I
> need to do in the same statement.
If I understand the question, and there is no key other than the
auto-incrementing integer, there might not be a good way. It sounds
like the database's design may have painted you into a corner.
I think you want
insert into B
insert into A with FK pointing to new rows in B
The way to do that is
insert into B
insert into A
select ... from B
where natural key = key of new rows
The insert-select statement gives you the magic integer based on
something you do know: the natural key of the data.
HTH.
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
