Hi,
I have a database table with 8 fields and i want to add a new column and copy the contents of one column to new column. if i try using select and insert number of rows is duplicating and insertion is going to end. how do i insert that contents to same row.
Almost right, use update instead of insert: UPDATE table SET name = title; HTH, Chris.