On Tue, 2005-02-15 at 17:56, steve cooley wrote:
> How do you you get the next auto increment value? I think I'm running
> into the insert...select problem. I want to duplicate records from one
> table to the _same_ table, with an incremented auto increment value.
>
> Can I do something like t
How do you you get the next auto increment value? I think I'm running
into the insert...select problem. I want to duplicate records from one
table to the _same_ table, with an incremented auto increment value.
Can I do something like this:
insert into table (autoincrement_key, field1, field2)
