|
Posted by VooDoo on 11/26/07 14:34
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??
Navigation:
[Reply to this message]
|