Subject: Re: Copying records using phpMyAdmin
From: Justin Dieters (enderak@gci.net)
Date: Mon Jul 08 2002 - 16:14:04 AKDT
Whoops... On second look, I think I missed a parentheses after
''SELECT'', but you get the idea.. :)
Justin
Justin Dieters wrote:
>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.
>
>
>
>
---------
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:14:20 AKDT