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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
