>From: "Rob Duncan" <[EMAIL PROTECTED]>
>The last_insert_rowid() function seems to be close to what I want. The
>trouble with it is that as soon as I add a row to the first child table
>its value will change and I will not be able to use it for any other
>child inserts.
Hi Ron,
SQLite doesn't su
Here are 2 tables to use in our example:
CREATE TABLE t1 (
t1_pk INTEGER PRIMARY KEY,
t1_value VARCHAR(20)
);
CREATE TABLE t2 (
t1_fk INTEGER,
t2_id INTEGER,
t2_value VARCHAR(20)
);
t1_pk would be the primary key on your main table (t1), t1_fk would be
foreign key to t1_pk an
Greetings,
I have what is, I think, a very basic SQL question, but I don't seem to
be able to find the answer. I'm almost a complete database novice, so
perhaps I have things completely wrong… I want to insert a row into
one table and have it automatically generate a primary key (the other
f
3 matches
Mail list logo
