Whats the easiest way to duplicate a row, specifiying only a new primary number? Is the easiest way: 1. "SELECT * where primarykey=oldnum" 2. roll through the fields, getting current fields and values 3. "INSERT <fields/values> where primarykey=newnum" ... etc? Or is there an SQL statement to achieve this ?? like "INSERT (SELECT statement) WHERE primarykey=newnum" ? Or are you going to riducule, saying 'what the hell do you need near-duplicate rows for'? :P Siggy
- Re: [PHP-DB] Near-duplicate a row ? Sigurd Magnusson
- Re: [PHP-DB] Near-duplicate a row ? Toby Butzon
- Re: [PHP-DB] Near-duplicate a row ? Stas Trefilov