Re: [PHP-DB] Near-duplicate a row ?

[Stas Trefilov]

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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]