At 16:59 -0700 9/10/04, Dan Sashko wrote:
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?
You can name all the columns except that one.
But why do you have a primary key if you want to allow duplicate values?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
