Duplicating a Record in MySQL
| From: | Roger Lewis | Date: | Sat, 19 Oct 2002 17:04:50 +0000 |
| Subject: | Duplicating a Record in MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-120612@lists.php.net to get a copy of this message | ||
It's not strictly php, but does anyone know an easy way to duplicate a
record in MySQL. It would be nice if you could write something like:
COPY * from table WHERE id = 6;
and have it insert a new record into the table with the next id number.
Roger Lewis