Re: Near-duplicate a row ?
| From: | (Stas Trefilov) | Date: | Tue, 23 Jan 2001 18:56:46 +0000 |
| Subject: | Re: Near-duplicate a row ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6139@lists.php.net to get a copy of this message | ||
Hello, "Sigurd Magnusson"!
You wrote:
> Whats the easiest way to duplicate a row, specifiying
> only a new primary
> number?
>
insert into <table> (<all_columns>) select <new_id>,
<columns> from <table> where <condition>
--
Piloteers do it on the road