From: Date: September 11 2004 1:59am
Subject: Copy a record
List-Archive: http://lists.mysql.com/mysql/172442
Message-Id: <00be01c49792$25f0e460$6720a8c0@DAN>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

hi, a quick question.

is there a way to duplicate a record (without knowing fields in advance) in
sql alone?
the only thing is know is that `id` is a primary key (autonumber)

something of this sort:

INSERT INTO the_table
SELECT * FROM the_table
WHERE id=the_number

this fails due duplicate entry for the primary key. Is there way to select *
minus the id field?

thx