Posted by Jerry Stuckle on 11/26/07 14:38

VooDoo wrote:
> Hi,
> i am trying to copy a completed field set from one table to another.
> I am using this SQL command:
> INSERT INTO doc_valid SELECT * from doc_temp where id=$id
>
> it works, but it also copy the index field id from my temp table to the
> valid table...
> the index are autoincrement primary key, and it should take the next index
> value....
>
> How can i make this copy and use the auto incremental index of the
> destination table??
>
>
>
>

Ask in comp.databases.mysql. This has nothing to do with PHP.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]