Posts by Filipe Cerejo • 1 point
1 post
-
-1
votes4
answers44
viewsA: Copy multiple records to the same table with change of values
Experiment as follows: INSERT INTO tags(group_tags, title, active) with cte as ( SELECT group_tags, title, active FROM tags WHERE group_tags = 2 ) SELECT 1, title, active FROM cte The first part…