Subject: Re: Copying records using phpMyAdmin
From: Justin Dieters (enderak@gci.net)
Date: Mon Jul 08 2002 - 16:09:44 AKDT
Hasn't been tested, but what about something like:
INSERT INTO <table> (
new_record_number,
<field1>,
<field2>,
<field3>,
<etc..>)
SELECT
<source_record_number>,
<field1>,
<field2>,
<field3>,
<etc..>)
FROM <table>
WHERE new_record_number = <somenumber>;
Justin
Mike Barsalou wrote:
>Am I blind or is there no direct way to make a duplicate record? Maybe it
>is my ignorance with SQL? Can someone help me out here?
>
>Mike
>
>---------
>To unsubscribe, send email to <aklug-request@aklug.org>
>with 'unsubscribe' in the message body.
>
>
>
>
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
This archive was generated by hypermail 2a23 : Mon Jul 08 2002 - 16:10:00 AKDT