Subject: RE: Copying records using phpMyAdmin
From: Mike Barsalou (mbarsalou@aidea.org)
Date: Mon Jul 08 2002 - 16:08:57 AKDT
For now my workaround was...type in the initial record...hit save...hit the
back button...change any needed items...hit save...hit the back button, etc.
Mike
-----Original Message-----
From: Justin Dieters [mailto:enderak@gci.net]
Sent: Monday, July 08, 2002 4:10 PM
To: Mike Barsalou; aklug@aklug.org
Subject: Re: Copying records using phpMyAdmin
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:11:14 AKDT