This article is tagged with:
Sql insert for each distinct value
and mysql
sql insert for each distinct value
insert into your_table (col1, col2, col3)
select distinct col1, 'newval', col3
from your_table
