I like to make some copies of some sql records.
I like to do this whitout storing the information in a temporary variable.
say that I have a table test with the records
a b c d e f.
I like to do a select * from test where a=1
and then insert a new (or more than one if the select return more than one answer)
record with a=2 and b,c,d,e and f should be the same as in the result from the select above.
Can someone help me out with this....