|
|
Posted by Kim Andrι Akerψ on 11/26/07 14:56
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??
Although this question has more to do with MySQL than PHP, and should
rather have been posed in comp.databases.mysql, you might try
specifying the field names you want to extract from the temp table
instead of * (which means ALL fields, including the "id" field).
--
Kim AndrΓ© AkerΓΈ
- kimandre@NOSPAMbetadome.com
(remove NOSPAM to contact me directly)
[Back to original message]
|