Skip to main content
A
Anonymous
October 8, 2007
Answered

Copy row in same table?

  • October 8, 2007
  • 2 replies
  • 439 views
Hello everyone!

Is possible to copy a row form a table and insert it as a new row?
Can this be done with cf functionality like cfupdate? or should i try and find an answer in sql?

tnx for any help!
This topic has been closed for replies.
Correct answer JR__Bob__Dobbs-qSBHQ2
INSERT INTO Table1 ( FieldA, FieldB, FieldC )
SELECT FieldA, FieldB, FieldC
FROM Table2
WHERE FieldD = SomeValue

2 replies

J
JR__Bob__Dobbs-qSBHQ2Correct answer
Inspiring
October 8, 2007
INSERT INTO Table1 ( FieldA, FieldB, FieldC )
SELECT FieldA, FieldB, FieldC
FROM Table2
WHERE FieldD = SomeValue
D
Dan_Bracuk
Inspiring
October 8, 2007
If you have a well designed database, no. Why would you want to anyhow?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices