[PHP] duplicating a row

[Bob Lockie]

I want to duplicate a row (back it up - copy to a table with the same 
schema) regardless of the table schema.
This in MySQL but I need a solution that can be made easily portable to 
other databases.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] duplicating a row

[Daniel Clark]

INSERT INTO new_table (column1, column2, ...)
SELECT column1, column2, ...
FROM original_table

I want to duplicate a row (back it up - copy to a table with the same 
schema) regardless of the table schema.
This in MySQL but I need a solution that can be made easily portable to 
other databases.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php