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


Reply via email to