Re: [SQL] Getting sequence value after inserting many rows at a time

2003-01-11 Thread Bruno Wolff III
On Sat, Jan 11, 2003 at 12:25:47 -0600, Maurício Sessue Otta <[EMAIL PROTECTED]> wrote: > Hi, > > I have a PHP script that do something like > this: > > INSERT INTO table_with_sequence (field1, > field2, fieldn) > SELECT field1, field2, ..., fieldn FROM table,table > > WHERE condition

Re: [SQL] Getting sequence value after inserting many rows at a time

2003-01-09 Thread Bruno Wolff III
On Thu, Jan 09, 2003 at 22:48:11 -0200, Maurício Sessue Otta <[EMAIL PROTECTED]> wrote: > Hi, > > I have a PHP script that do something like this: > > INSERT INTO table_with_sequence (field1, field2, fieldn) > SELECT field1, field2, ..., fieldn FROM table,table > WHERE condition, conditio

[SQL] Getting sequence value after inserting many rows at a time

2003-01-09 Thread Maurício Sessue Otta
Hi,   I have a PHP script that do something like this:   INSERT INTO table_with_sequence (field1, field2, fieldn) SELECT field1, field2, ..., fieldn FROM table,table WHERE condition, condition   My doubt: Will the rows just inserted in "table_with_sequence" always be sequencial? (won't