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? -----Original Message----- >From: Scott Haneda <lists@newgeo.com> >Sent: Sep 14, 2006 5:06 PM >To: MySql <mysql@lists.mysql.com> >Subject: Cloning or duplicating a record > >Can someone tell me how to take one record and duplicate it exactly, with >the exception of the pk, which I want to increment as usual. > >I think I need insert select, however, I don't want to name all the fields, >as it would break over time, if I add or subtract fields. I seem to recall >using a wildcard tossed me up an error about a duplicate key. >-- >------------------------------------------------------------- >Scott Haneda Tel: 415.898.2602 ><http://www.newgeo.com> Novato, CA U.S.A. > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/mysql?unsub=h...mindspring.com >      |
Linear Mode
