SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:16 PM
| ||||
| ||||
 Re: Cloning or duplicating a record > how about: > insert into <table_name> select * from <table_name> where <select criteria> > > is the primary key an auto sequence? This is what happens when I try: insert into logbook select * from logbook where id = 1; ERROR 1062: Duplicate entry '1' for key 1 -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A.      |
|
02-27-2008, 09:16 PM
| ||||
| ||||
| Re: Cloning or duplicating a record At 3:31 PM -0700 9/14/06, Scott Haneda wrote: > > how about: >> insert into <table_name> select * from <table_name> where <select criteria> >> >> is the primary key an auto sequence? > >This is what happens when I try: >insert into logbook select * from logbook where id = 1; >ERROR 1062: Duplicate entry '1' for key 1 >-- >------------------------------------------------------------- >Scott Haneda Tel: 415.898.2602 ><http://www.newgeo.com> Novato, CA U.S.A. YOu'll have to list the fields explicitly, except for the primary key. For example, if your table has columns: id (PK) data_1 data_2 data_3 you should be able to do insert into table_name (data_1, data_2, data_3) select data_1,data_2,data_3 from table_name where id=1 The insert failed because you were - as the error message said - trying to insert a record with an existing primary key, which is unique. Check mysql manual for more info on syntax of insert command. steve -- +--------------- my people are the people of the dessert, ---------------+ | Steve Edberg http://pgfsun.ucdavis.edu/ | | UC Davis Genome Center sbedberg@ucdavis.edu | | Bioinformatics programming/database/sysadmin (530)754-9127 | +---------------- said t e lawrence, picking up his fork ----------------+ |
Linear Mode
