Hi all - I would like to duplicate a record based on the PK [ID].
I have searched and can't seem to find an easy way to do this without specifying all fields to insert.
I am not familiar with SQL syntax, so some code would be handy.
Basically this is what I would hope for:
Code:insert into tbl_name entire_row where id = variable