Posts by Filipe Cerejo • 1 point

• -1

  votes

  4

  answers

  44

  views

  A: 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…

  mysql sql

  answered 5 years, 4 months ago Filipe Cerejo 1