You are here: Re: copy field from one table to another « PHP Programming Language « IT news, forums, messages
Re: copy field from one table to another

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)

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация