is is
> not one of them) so DO NOT include it in either the INSERT clause or the
> SELECT clause.
>
> Did this help or make it worse?
> Respectfully,
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>
>
> John Mistler
> <
ED]
Triand, Inc.
www.triand.com
O: (512) 248-2287
M: (713) 252-4688
-Original Message-
From: John Mistler [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 1:40 PM
To: [EMAIL PROTECTED]
Subject: COPY row?
Is there a COPY row or DUPLICATE row command? I would like to duplicate
a
row with in
cc:
Fax to:
06/10/2004 03:40 Subjec
Is there a COPY row or DUPLICATE row command? I would like to duplicate a
row with in a table with 38 columns (auto-incrementing the Primary Key on
the copied row, of course) and then alter the entry in ONE of its columns.
Can this be done without doing a SELECT, then INSERT, then UPDATE?
Thanks