insert into table (col1, col2, ...) ( select newval_or_expression, col2, ... from table where ... )