Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
insert from one table into same table
- Thread starter Naoise
- Start date
swampBoogie
Programmer
Code:
insert into t select 5,<otherColumns> from t where id = 4- Status
Similar threads
- Locked
- Question